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 the performance killers that most DBAs and Devs are often unaware of. 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?

Fill out the form to get a recording of the session.

kevin-kline.png

 Kevin Kline
 Principal Program Manager

Charles_Kim-167485-edited.jpg

 Charles Kim
 Founder of Viscosity North America

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 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.