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.
Keywords
- Wait Time
- Execution Plan
- Context Switching
- Performance Counter
- Wait Stat
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
This is a preview of subscription content, access via your institution.
Buying options
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