Server applications only use up 50% of available CPU time

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.
swabeuiAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bartender_1Microsoft Network AdministratorCommented:
Hi swabeui,

>>they don't seem to be working as hard as they could be.
Is this the difficulty?
If this is what you are concerned about, don't worry. typically, I monitor the CPU usage to make sure it's not too high.
When it becomes too high, then I make changes to bring it back down. I see nothing wrong with your current configuration and the performance of your servers.
 
Hope this helps!

:o)

Bartender_1
0
swabeuiAuthor Commented:
The problem is on certain tasks I want to happen faster in certain situations, such as a database update.  There are other instances (with terminal server) that users run database changes and the application will only use 5-10% of the CPU.  I usually have them cancel the task and I run it myself so it won't take 5-6 hours when it should take less then 30 minutes.
0
swabeuiAuthor Commented:
Admins:

Please close this question.  My question was never answered.
0
Bartender_1Microsoft Network AdministratorCommented:
Hmmmm..... I'm really dissappointed with the notifs. I don't recall receiving a notif from this question when swabeui posted back.

swabeui:

I'm sorry I never got back to you, and was unable to assist you with your difficulty, my notifs appear to be missing.

In response to your question about your database updates: Depending on how your database works, you will have to change the priority settings for the process that actually updates the database.

Alternatives: Create a script that runs at certain times, run it as yourself (to have the permissions) and set the priority to realtime, then have it update your database.

Depending on your Database, you could post a question here:http://www.experts-exchange.com/Databases/
 Someone there will most likely be able to assist you in your specific database needs.

Hope this points you in the right direction!

:o)

Bartender_1
0
PashaModCommented:
Closed, 250 points refunded.
PashaMod
Community Support Moderator
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows 2000

From novice to tech pro — start learning today.