Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lianvh999
Starting Member
1 Post |
 Posted - 2013-04-17 : 09:29:51
|
| Good Day,We are running SQL Server 2008R2 Ent 64 bit with 32 CPUs and 256 gig of memory. We ran diagnostic scripts to identify any bottlenecks and found that ony 4 processors are relatively busy processing only between 4 and 7 processes each.When I ran sp_who3 I noticed that the lastwaittype on some of the processes is SOS_SCHEDULER_YIELD , meaning the cpus are under pressure . Now I am baffled ,because the users also are not complaining . Any ideas ? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-04-17 : 12:25:28
|
| This is not necessarily an indication of CPU pressure.What are you seeing in perfmon for % Processor time? Have a look at this blog and the Waits and Queues White Paper |
 |
|
|
|
|
|
CPU Pressure