Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 How To Identify CPU Problem?
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Posting Yak Master

132 Posts

Posted - 12/11/2012 :  09:27:57  Show Profile  Reply with Quote
Good morning all.

I've been reading and cramming lately on the subject of Performance tuning. Heavy CPU use comes up a lot in many of the articles that I read. It comes up as something to identify first during decision making time as far as how to go about to solve a particular performance problem many times. What method do we use to determine that CPU is stressed? All I know of is clicking on task manager and looking at performance, which according to me is fine because it varies from 0% to 28% throughout the day. Do you folks identify CPU stress in a different way? What do we call this, instead of saying "CPU Stress"? While we're at it, what's this yak thing I see all over everyone's user name? Isn't a yak an animal?

Most Valuable Yak

15732 Posts

Posted - 12/11/2012 :  09:51:34  Show Profile  Visit robvolk's Homepage  Reply with Quote
The mini-bible on waits:

The main one to look for in diagnosing CPU pressure is SOS_SCHEDULER_YIELD. Paul gives guidelines on how much represents an overloaded CPU. If you don't see those levels then you're not likely CPU bound, even if you're at 50% CPU utilization all the time.

SQLTeam Yak History:
Go to Top of Page

Posting Yak Master

132 Posts

Posted - 12/13/2012 :  09:05:51  Show Profile  Reply with Quote
Thanks for the info.
Go to Top of Page

Flowing Fount of Yak Knowledge

United Kingdom
2179 Posts

Posted - 12/13/2012 :  09:38:34  Show Profile  Visit jackv's Homepage  Reply with Quote
A high percentage SOS_SCHEDULER_YIELD does not always mean CPU pressure. Use perfmon counters to cross-check.

Assess response from sys.dm_os_schedulers . From BOL “Returns one row per scheduler in SQL Server where each scheduler is mapped to an individual processor. Use this view to monitor the condition of a scheduler or to identify runaway tasks”

Jack Vamvas
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000