Troubleshooting SQL server High CPU : Part 1

Troubleshooting SQL server High CPU : Part 1

Rate This
  • Comments 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 the video in better quality, please check the link: - http://channel9.msdn.com/posts/SQL-server-High-CPU--Part-1

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

Attachment: Demo_Queries_for_VBlogging_High CPU_Part1_2.txt
Leave a Comment
  • Please add 5 and 5 and type the answer here:
  • Post
  • Hi Niraj

    Can you please enclose the scripts, you used in your demo. It would be much helpful and convenient for everyone. Your help is much appreciated.

    Cheers

    Murali

Page 1 of 1 (1 items)