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

  • Article

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