Single-Query Wait Stats

Robert Davis shows off a new wait stats-related feature in 2016 SP1:

Paul’s process gives you info on every instance of a wait the query experienced and it’s very easy to aggregate those results to see the top waits and their total effect on a query. Quite often though, you don’t need a lot of detail. You don’t need to know every wait, just the top several. If you are already generating the actual query plan to have a in-depth look at the plan, wouldn’t it be nice if the query wait stats were already in there for you?

Now they are. In SQL Server 2016 (I’m told it came in SP1, but I don’t have a non-SP1 instance to verify that), the actual execution plan includes the top waits for the query execution in the plan. You can see them by clicking on the left-most (first) operator in the plan and viewing the Properties (shortcut F4). It will list the top waits right there in the properties dialog for you.

Getting single-query wait stats in the execution plan makes life so much simpler.

Related Posts

T-SQL Tuesday 88 Roundup

Kennie Nybo Pontoppidan has a roundup for this week’s T-SQL Tuesday: Last duty for me as a T-SQL Tuesday host is to write up a summary of all the posts. Soooo, here we go… Kennie goes the extra mile and summarizes each story with a moral.

Read More

Indexing Woes

Shane O’Neill relates a tale of trying to create an index with a SQL Agent job.  Easy, right? Now I’m angry too since I count these failures as personal and I don’t like failing, so I get cracking on the investigation. Straight away, that error message doesn’t help my mood. I’m not indexing a view! I’m not […]

Read More

Categories

February 2017
MTWTFSS
« Jan Mar »
 12345
6789101112
13141516171819
20212223242526
2728