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 |
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
 Posted - 2008-01-04 : 10:00:06
|
| Dear all,I appear to have a CPU bottleneck. The CPU is averaging at about 80% with SQL Server causing the most of this work. In addition to this, peaking in the same areas in Perfmon is the processer queue length.Can anyone advise possible reasons why SQL Server would be working hard like this?Drew---------------------"It's Saturday night; I've got no date, a two litre bottle of Shasta, and my all-Rush mix tape... LET'S ROCK." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-01-04 : 13:26:59
|
| Poor database design, badly written queries, missing indexes, old hardware that doesn't meet the database needs, ...Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
High Processer Queue Length