60 minute session
Introduction to Wait Statistics & SQL Server Detective - Investigating Wait Statistics
In this session, attendees are introduced to wait statistics in SQL Server and learn how these built-in performance statistics provide insight into bottlenecks within a SQL Server instance. We start with an explanation of how waits arise and cover a number of common wait types. Next, we look at how SQL Server records these and how you can use this information for performance troubleshooting.
The session combines theory with practice, including analysing Dynamic Management Views and how to interpret common wait types. This gives attendees a solid foundation to better understand performance problems and optimise in a targeted way.
Learning goals
- Understanding what wait statistics are and why they are important for performance analysis
- Gaining insight into how SQL Server generates and records wait statistics
- Learning to work with relevant DMVs such as sys.dm_os_wait_stats and sys.dm_os_waiting_tasks
- Recognising and interpreting common wait types (such as CXPACKET, LCK_M, PAGEIOLATCH)
- Getting practical tools to analyse and diagnose performance problems using wait statistics
Level
Intermediate
Topics
Materials