Why to look at "Wait Statistics" to troubleshoot SQL Performance


Here we will discuss on Waits in the context of SQL Server:

Highlights of this video blog :-

1. What is wait and why we need to focus on wait?

2. Lifecycle of a session

3. Analogy to explain waits

4. Types of Waits.

5. Where to see waits in SQL Server

6. Demo

To watch the video in better quality,please check the video :- https://channel9.msdn.com/posts/Why-to-look-at-Wait-Statistics-to-troubleshoot-SQL-Performance

  

Presented By: – Sakthivel Chidambaram,SE,Microsoft GTSC
Reviewed By: –  Pranab Mazumdar,SEE,Microsoft GTSC

Comments (4)

  1. ab5sr says:

    Nice post, thank for sharing this.

  2. kamal says:

    ya verry nice thanks for giving this usefull information

  3. Banupriya says:

    Fantastic Post… Very useful. Thanks Sakthi

  4. Dinesh Vishe says:

    Nice post