Analyzing Wait Statistics

  • Benjamin Nevarez
Chapter

Abstract

One of my main recommendations for troubleshooting a performance problem when a particular issue is lacking information is to run a SQL trace or extended events session to find out the most expensive queries. This method will usually show us the most expensive queries based on one or more metrics including duration, CPU usage, logical and physical reads, writes, rows, and so on. Many times the metric of choice is duration, or how long the query took to execute. We usually assume this entire duration is usable work, which of course can be optimized. In a lot of cases, this method can find the troubled queries, and tuning them solves the performance problem.

Keywords

Wait Time Processor Time Event Session Wait Statistic Work Thread 
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

© Benjamin Nevarez 2016

Authors and Affiliations

  • Benjamin Nevarez
    • 1
  1. 1.Santa ClaritaUSA

Personalised recommendations