Ten Surprising Performance Killers on Microsoft SQL Server


Microsoft SQL Server is among the most popular and widely used data platforms with a reputation for resilience, performance, and ease of administration. But wait - performance killers are lurking deep inside your SQL Servers!

Learn about these performance killers that most DBAs and Devs are unaware--often, DBAs and Devs are not even aware that the database servers are virtualized. We will cover a variety of significant issues, ranging from VMware considerations, server-side OS settings, file layout, memory settings, and database design to coding issues like data types and cursors.

This session will answer questions like: 

  • What VMware, Windows Server, and SQL Server defaults are likely to make application performance worse?
  • What is a forwarded record indicator and why is it a red flag?
  • Why do GUIDs and oversized data type columns decrease performance?
  • How does changing a database file layout help or hurt performance?
  • What memory setting should you always change from the default?

Interested in additional SentryOne webinars?  Check our webinar library.

Available On Demand

Kevin Kline

Kevin Kline

Principal Program Manager

Kevin (@kekline) is responsible for expanding SentryOne's technical sales and marketing initiatives and is also heavily involved in product design activities. He is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a renowned database expert, software industry veteran, Microsoft SQL Server MVP, Google Author, and long-time blogger at sqlblog.com and at kevinekline.com.

Charles Kim

Charles Kim

Founder of Viscosity North America

Charles is an Oracle ACE Director, Oracle Certified DBA, a Certified RAC Expert and Certified Exadata Implementation Specialist. He is also a VMware vExpert and a VMware Certified Professional. Charles specializes in RAC, Exadata, Virtualization and authored 8 books. He holds certifications in Oracle, VMware, Red Hat Linux, and Microsoft SQL. Charles presents regularly at local, regional, national, and international Oracle conferences.

Companies with the highest demands for database performance choose SentryOne