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 the video in better quality,please check the link: -https://channel9.msdn.com/posts/Troubleshooting-SQL-server-High-CPU--Part-2

 

Presented By: - Niraj P Mehta,Senior support engineer,Microsoft GTSC
Reviewed By: - Pranab Mazumdar,Senior support escalation engineer,Microsoft GTSC                          
                         Rishi Maini,Senior support escalation engineer,Microsoft GTSC

Demo_Queries_for_VBlogging_High CPU_Part1_2.txt

Comments

  • Anonymous
    May 09, 2015
    Nice one.