Level: Introductory to Intermediate
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