Advertisement

Healthy SQL pp 43-80 | Cite as

Waits and Queues

  • Robert Pearl

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.

Copyright information

© Robert Pearl 2015

Authors and Affiliations

  • Robert Pearl
    • 1
  1. 1.NYUS

Personalised recommendations