An Expert Guide to SQL Server Performance Tuning

Database professionals agree – SQL Server performance tuning is challenging. And, as with many daunting tasks, often the toughest part of performance tuning in SQL Server is knowing where to start.

We asked several SQL Server experts to share their advice on what to look for when the database is performing slowly. During Quest’s Database Training Days webcast series, we invited Pinal Dave, SQL Server Performance Tuning Expert, Janis Griffin, Oracle ACE and Brent Ozar, Microsoft Certified Master to host hands-on training sessions where they identified quick wins, common performance inhibitors and the best places to begin and focus your efforts when tuning SQL Server.

This e-book is a compilation of their top tips to help guide you in your performance tuning efforts. You’ll learn:

• Important areas to check first, such as the compatibility level and cardinality estimation
• Why you should pay attention to row goals
• The critical reasons to monitor wait time
• Why it’s vital to know how to read an execution plan
• Which SQL Server performance tuning metrics to focus on
• And much more…