Troubleshooting SQL server High CPU : Part 2

Troubleshooting SQL server High CPU : Part 2

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/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

Attachment: Demo_Queries_for_VBlogging_High CPU_Part1_2.txt
Leave a Comment
  • Please add 4 and 8 and type the answer here:
  • Post
  • Nice one.

Page 1 of 1 (1 items)