High CPU utilization on server

Question

Server Configuration:

Problem:

Very slow response of the website due to HIGH CPU usage.
Sometimes Site works fine, but suddenly it goes slow down and static HTML pages also not responding quickly.
Whenever we restart the server or SQL SERVER service, site works fine for while, but after sometime site performance decreased and site goes slow down.

We Tried Solution:

Optimized all Stored Procedure, Remove all unwanted TEMP tables from Stored Procedures.
Removed all unwanted code, comments. Unused links, file references from the source code.
There is antivirus on the server, we scanned whole server but no virus found.
We stop unwanted services in the server.
We remove unnecessary application from the server too.

Possible duplicate: http://stackoverflow.com/questions/9615742/sql-server-2008-r2-high-cpu-usage?rq=1 — pleinolijf, Oct 19 '12 at 10:52
@pleinolijf thanx for your replay,but i have already tried the same,but i dont get any result for that query,that means the problem is not regarding that issue — , Oct 19 '12 at 11:38
So High CPU usage - What process is doing it? What's the typical usage you expect in normal operations? You're approaching this as if it were a fault - how have you eliminated the possibility that it's simply a capacity issue? As its a virtual machine, how many cores are allocated to it? How much contention for host resources is there? — Rob Moir, Dec 03 '12 at 08:33

score 0 · Answer 1 · edited Dec 03 '12 at 08:07

0

Start clearing the process cache.

Analyze page replacement statistics.

Remove disk level compression if any.

edited Dec 03 '12 at 08:07

John Gardeniers

answered Dec 03 '12 at 07:40

rao

1 Answers1