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
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