Abstract
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 three of the most useful DMVs: sys.dm_os_wait_stats, sys.dm_os_waiting_tasks, and sys.dm_exec_requests.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Electronic Supplementary Material
Below is the link to the electronic supplementary material.
Rights and permissions
Copyright information
© 2015 Enrico van de Laar
About this chapter
Cite this chapter
van de Laar, E. (2015). Querying SQL Server Wait Statistics. In: Pro SQL Server Wait Statistics. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-1139-7_2
Download citation
DOI: https://doi.org/10.1007/978-1-4842-1139-7_2
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-1140-3
Online ISBN: 978-1-4842-1139-7
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books