• Blog Post: 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...
  • Blog Post: 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 ----------- ----------- ------------------...
Page 1 of 1 (2 items)