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 |
|
rkc01
Starting Member
43 Posts |
 Posted - 2003-01-17 : 15:33:26
|
| I'm getting information which seems to contradict itself. In perfmon I'm monitoring various counters, (memory, disk, page file, processor, sql server, etc...) There are no memory or disk bottlenecks. SQL looks good too. The Processor counters are throwing me a little. I've looked at a lot of information from differtent sources on these conters but none of it seems to explain what I'm seeing. These are the 3 counters and their values taken over an 18 hour period,(Sampled every 5 minutes):Server Work Queues\Queue Length - Last 0, Average 0, Min 0, Max 0System\Processor Queue Length - Last 4, Average 6.7, Min 2, Max 28Processor\%Processor Time - Last 1.4, Average 14, Min 1.3, Max 57I know you can't see the graph but the processor time max value is just a spike, (I can email anyone the logs if the want to see). In all the docs I've read they says that sustained values greater than 2 for System\Processor Queue Length are an indication of a processor bottleneck. They go on to say that this may occur in conjunction with a High Processor\%Processor Time > %90 but can also occur with activity as low as %60. This processor is now where even close to a %60 average. In addition, the Server Work Queues\Queue Length should also be over threshold (>4), yet it's 0 across the board. The box has been acting sluggish and that's what prompted the monitor. I don't see anything out of the ordinary expect for these counters. The disk is fragmented to hell and back and I'm going to recommend a defrag ASAP but if that doesn't help.....I'm monitoring processes now to see if I can determine which one(s) may be abusing the processor. Has anyone else ever run into this?Thx,-Rob |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-18 : 23:38:11
|
| When you were running the Performance Monitor, was the server experiencing performance problems? Did you also take a look at memory counters? Just by looking at your counter numbers, I would say that the server is not experiencing a performance bottleneck. I would take a look at other counters to determine what the problem is, such as: memory, SQL Server: buffer cache hit ratio, disk reads and writes, disk queue length, and the page file. Post back to this thread if you see any numbers that are high and we'll see if we can help you. |
 |
|
|
Jay1Jay
Yak Posting Veteran
50 Posts |
Posted - 2003-01-22 : 15:29:19
|
| I have seen at times that SQLSERVER.exe take utilizes about 70-80% of the processors.. I have not been able to find anything on this either, so if you find something please let me know.Thanks,Jay |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-22 : 16:17:46
|
| Jay, you should take a look at sp_who to see what processes are running on your server when the CPU utilization is high. You could also run SQL Profiler to get all of the detail that you will need to figure out what the server is doing. |
|
|
|
|
|
|
|
|
Processor Bottleneck?