Pro SQL Server 2019 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server

© Enrico van de Laar 2019

Enrico van de LaarPro SQL Server 2019 Wait Statisticshttps://doi.org/10.1007/978-1-4842-4916-1_2

2. Querying SQL Server Wait Statistics

Enrico van de Laar¹ 

(1)

Drachten, The Netherlands

 

With the introduction of Dynamic Management Views (DMVs) in SQL Server 2005, viewing and analyzing wait statistics has become a lot easier and less tedious. In SQL Server versions prior to SQL Server 2005, we were limited to the DBCC SQLPERF('WAITSSTATS') command to view wait statistics. Presently there are a variety of DMVs that return wait statistics–related information, and in this chapter, we will take a detailed look at four of the most useful DMVs: sys.dm_os_wait_stats, sys.dm_os_waiting_tasks, sys.dm_exec_requests, and sys.dm_exec_session_wait_stats ...