• Blog Post: Troubleshooting SQL server High CPU : Part 2

    In this blog we have explained the various causes for SQL to drive the processors i.e. high CPU and the steps to troubleshoot it. Possible causes that can lead to high CPU usage by SQL server:- 1.Inefficient Query Plans 2. Intra- query Parallelism 3. Excessive Cache look up time To watch...
  • Blog Post: Troubleshooting SQL server High CPU : Part 1

    In this blog we have explained the various causes for SQL to drive the processors i.e. high CPU and the steps to troubleshoot it. Possible causes that can lead to high CPU usage by SQL server:- 1.Inefficient Query Plans 2. Intra- query Parallelism 3. Excessive Cache look up time To watch...
  • 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 (3 items)