SQL Server Performance Tuning and Optimization

SQH08 Top 10 Wait Types Everyone Should Know


11:00am - 12:15pm

Level: Introductory to Intermediate

Janis Griffin

Database Performance Evangelist


Analyzing Wait Types is a newer method for tuning SQL Server instances. As a result, there's often confusion on exactly what the data means. This presentation will focus on the top 10 most frequently seen Wait Types and review several real-life case studies of using SQL Server Wait Type data coupled with Response time performance analysis to solve the most difficult performance related issues.

You will learn:

  • How to view and capture wait types for SQL Statements in order to gather clues on how to tune them
  • The top ten most common wait types in a SQL Server instance. In addition, several solutions will be shown so the participant can quickly reduce the time spent on each one
  • Why Response Time Analysis is the best method for finding and fixing the queries impacting your application / database users