[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Server applications only use up 50% of available CPU time

Posted on 2003-11-25
7
Medium Priority
?
116 Views
Last Modified: 2010-04-14
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.
0
Comment
Question by:swabeui
  • 2
  • 2
5 Comments
 
LVL 22

Expert Comment

by:Christopher McKay
ID: 9819437
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
 

Author Comment

by:swabeui
ID: 9819478
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
 

Author Comment

by:swabeui
ID: 10047578
Admins:

Please close this question.  My question was never answered.
0
 
LVL 22

Expert Comment

by:Christopher McKay
ID: 10669533
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
 

Accepted Solution

by:
PashaMod earned 0 total points
ID: 10705392
Closed, 250 points refunded.
PashaMod
Community Support Moderator
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

NTFS file system has been developed by Microsoft that is widely used by Windows NT operating system and its advanced versions. It is the mostly used over FAT file system as it provides superior features like reliability, security, storage, efficienc…
In this article I will be showing you how to subnet the easiest way possible for IPv4 (Internet Protocol version 4). This article does not cover IPv6. Keep in mind that subnetting requires lots of practice and time.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Screencast - Getting to Know the Pipeline

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question