Freigeben über


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

  • Anonymous
    June 20, 2012
    Nice post, thank for sharing this.

  • Anonymous
    September 12, 2012
    ya verry nice thanks for giving this usefull information

  • Anonymous
    November 11, 2013
    Fantastic Post... Very useful. Thanks Sakthi

  • Anonymous
    May 09, 2015
    Nice post