% processor and % user time opinion

[timc]

I have a server with little control over most of the codeset and db design. Recently I have seen both the Processor - %Processor time and Processor - % User time go fom about 6.3 to about 24.3. The system queue length has also gone from about .2 to 1.1. In my humble opinion both of the are signs of a problem coming (luckily the cache hit ratio is still sitting at about 99%). I have been running profiler to catch the things that take more that 4500 MS, and I can probably tie the 2 together. Any opinions, or real world comparisons appreciated

[MAK]

run database maintenance (reindex and update statistics) and see the change in performance.

[skhanal]

You should schedule a regular reindex and update statistics job. The frequency will depend on how fast data changes in your environment.

[timc]

Indexes are rebuilt every 3 days