Server applications only use up 50% of available CPU time
Posted on 2003-11-25
I have a couple servers with multiple processors and recently the workload of those servers has gone up, however they don't seem to be working as hard as they could be.
A perfect example of this is when I try and do database updates with Microsoft Access. I have Access running on the server itself as well as the database I am updating, but when I run large queries or updates the "total" processor power averages at 50%. Sometimes it's lopsided with one CPU running at 90% and the other at 10%
I have tried running some of these applications in REALTIME, and I have noticed some improvement, but they are still not running at full power. I do have the servers set to focus on background applications instead of foreground and thought that might have something to do with it, but wanted to make sure before I started changeing things.