x

Please Sign-In to Access this Report

To access other reports on the platform please sign in with your username and password, or register for a free account to get unlimited access and insight customized for you.

Ebook Quest An Expert Guide to SQL Server Performance Tuning

An Expert Guide to SQL Server Performance Tuning

Top tips to help guide you in your performance tuning efforts

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.

Report Snap Shot

  • 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…