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 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.
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
Rights and permissions
Copyright information
© 2019 Enrico van de Laar
About this chapter
Cite this chapter
van de Laar, E. (2019). Querying SQL Server Wait Statistics. In: Pro SQL Server 2019 Wait Statistics. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-4916-1_2
Download citation
DOI: https://doi.org/10.1007/978-1-4842-4916-1_2
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-4915-4
Online ISBN: 978-1-4842-4916-1
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books