Level: Introductory to Intermediate

Janis Griffin

Database Performance Evangelist

Solarwinds

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