Abstract
Now that the road map has been built, you are on your way to a healthy SQL Server infrastructure. In this chapter, you will learn about one of the most effective methodologies for performance tuning and troubleshooting. The key methodology is waits and queues, which is an accurate way to determine why your SQL Server is performing slowly and to pinpoint where the bottleneck is. By analyzing the wait statistics, you can discover where SQL Server is spending most of the time waiting and focus on the most relevant performance counters. In other words, by using this process, you will quickly discover what SQL Server is waiting on.
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
© 2015 Robert Pearl
About this chapter
Cite this chapter
Pearl, R. (2015). Waits and Queues. In: Healthy SQL. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-6772-0_3
Download citation
DOI: https://doi.org/10.1007/978-1-4302-6772-0_3
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-6773-7
Online ISBN: 978-1-4302-6772-0
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books