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

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

Rate This
  • Comments 3

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 :- http://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

Leave a Comment
  • Please add 7 and 6 and type the answer here:
  • Post
  • Nice post, thank for sharing this.

  • ya verry nice thanks for giving this usefull information

  • Fantastic Post... Very useful. Thanks Sakthi

Page 1 of 1 (3 items)