Pro SQL Server 2022 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

T. LaRock, E. van de LaarPro SQL Server 2022 Wait Statisticshttps://doi.org/10.1007/978-1-4842-8771-2_2

2. Querying SQL Server Wait Statistics

Thomas LaRock¹   and Enrico van de Laar²

(1)

East Longmeadow, MA, USA

(2)

Drachten, The Netherlands

 

With the introduction of Dynamic Management Views (DMVs) and Dynamic Management Functions (DMFs) in SQL Server 2005, viewing and analyzing wait statistics became easier and less tedious. In SQL Server versions prior to SQL Server 2005, users were limited to the DBCC SQLPERF('WAITSSTATS') command to view wait statistics. Presently, there are a variety of DMVs which return wait statistics related information, and in this chapter, ...