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 informationAnonymous
November 11, 2013
Fantastic Post... Very useful. Thanks SakthiAnonymous
May 09, 2015
Nice post