Blog Post

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

Play Why to look at "Wait Statistics" to troubleshoot SQL Performance
Sign in to queue

Description

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

Presented By: - Sakthivel Chidambaram,SE,Microsoft GTSC
Reviewed By: -  Pranab Mazumdar,SEE,Microsoft GTSC

 

Embed

Download

Download this episode

The Discussion

Add Your 2 Cents