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 |
|
john.burns
Posting Yak Master
100 Posts |
 Posted - 2006-10-02 : 14:50:06
|
| Is 62% avg processor time too high for a SQL serverto perform well.I would like to see this number closer to 40%. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-02 : 14:51:32
|
| 62% is fine. Of course lower is better. CPU becomes a bottleneck when the average cpu is around 80-90%. Check out sql-server-performance.com for more information on specific performance monitor counter values.Tara Kizer |
 |
|
|
john.burns
Posting Yak Master
100 Posts |
Posted - 2006-10-02 : 14:59:55
|
| O.k I will do that ..thanks Tara |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-10-02 : 15:10:06
|
| If you have an 8cpu system with 62% avg processor time then I would agree with tara. If you have a single CPU environment with 62% avg then i think you have the beginnings of a problem.You could do some profiler traces to see what SQL is taking the most CPU and see if these statements can be tuned in any way. -ec |
|
|
|
john.burns
Posting Yak Master
100 Posts |
Posted - 2006-10-02 : 16:06:03
|
| 8 cpu.will profile for query tuningthanks |
|
|
|
|
|
|
Processor Time