Reducing CPU usage on a SQL Server application

Tags:
CPU usage
Microsoft Windows Server 2003
SQL Server 2005
SQL Server performance
I have Windows Server 2003 and with SQL Server 2005 installed. I run my timesheet software on that SQL server, but CPU usage reaches 70% to 80% when the program is running on many consoles on the client side. Is there a solution to reduce CPU usage?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Some things you can start by looking at are:

Buffer cache hit ratio.
Disk performance
Recompiles
Procedure cache hit ratio
Your disk IO may be high which is driving up the CPU
You may need more RAM which is causing the CPU and Disk IO to go up
You may need to add indexes to the database to optimize the query performance.

Without more details as to why the CPU is high there isn’t any quick fix which will lower the CPU usage.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Technochic
    What about your event logs? Any system errors? A lot of page files? How much memory do you have on the system and what is the memory utilization during the high processor usage?
    57,010 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following