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?