The DBA Fundamentals VG offers training and support to individuals interested in a solid DBA foundation.

Event Display
Meeting Detail

Tue, Dec 12 2017 12:30 (UTC+10:00) Brisbane


Ten Surprising Performance Killers on Microsoft SQL Server

RSVP: None

Ten Surprising Performance Killers on Microsoft SQL Server

Microsoft SQL Server is among the most popular and widely used data platforms of all time 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 of in this demo-packed session. We will cover a variety of significant issues, ranging from 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 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? Learn these performance killers now so that you will save millions of CPU cycles in the future. These mistakes are the “low hanging fruit” of SQL Server application performance. Once you apply the lessons learned from this session, you will you’re your applications performing at a higher level of efficiency and effectiveness than before.


Kevin Kline is a database expert and Principal Program Manager at SentryOne, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS, author of many books, blogger, columnist, and popular international speaker. Kevin’s best known book is the best-selling SQL in a Nutshell and contributes monthly to Database Trends & Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/Authors/KevinKline.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids