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 |
|
deepakmnair
Starting Member
4 Posts |
 Posted - 2005-12-19 : 03:05:19
|
| Hi,The sqlsrv.exe process has been consuming a high number of cpu cycles and time and seems not be decreasing at all. Can somebody point me in the right direction as to how to identify the bottleneck and resolve the same at the earliestThanks in advance |
|
|
makimark
Starting Member
34 Posts |
Posted - 2005-12-19 : 04:00:38
|
| check your disk que lengths counter in perfmon. Should be <2 per disk spindle. If its very high then your disks are not writing transactions away fast enough... |
 |
|
|
deepakmnair
Starting Member
4 Posts |
Posted - 2005-12-19 : 05:28:48
|
| i checked it and found Disk Queue Length to be at an average of 15, is this an issue, how to remedy it...? Thanks |
|
|
|
activecrypt
Posting Yak Master
165 Posts |
|
|
|
|
|
sqlsrv.exe consuming high CPU cycles