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…

4

NORECOMPUTE : Can lead to SQL server performance degradation!!

ANALYSIS:- In this case when we captured PSSDiag and noticed huge recompiles due to AutoStat updates, here’s a snippet of what we noticed in SQL Server 2005 Vs SQL Server 2008 on the same machine. SQL 2008 ========= EventID Occurrences Description ———– ———– ————————————————– 58 724 Auto Update Stats 166 508 SQL:StmtRecompile SQL 2005 =======…

0