January 7, 2009 at 11:30 am
Hello,
I have this Server with below specs,
Intel (R) Xeon(R) CPU
E5420 @2.50 GHz
2.49 Ghz. 4.00 GB of RAM
It has 4 processors, it suppose quite powerful for what we use, there are few driver scanners(150) gett
ig data of there, the CPU Usage stays on max. whereas it should not go more tha 30 to 35 %,
When go to the task manager to see what process is consuming the most of the space, I sqlsrvr.exe is consuming 95 % of it,
Any advice is much appreciated,
Thanks,
Dev
January 7, 2009 at 11:58 am
Try running profiler and see what are the queries that are consuming most of the CPU and tune them one at a time.
Also, make sure AUTO SHRINK and AUTO CLOSE are not ON for any of the database. Also, see if reindexing or any other maintenance job is under execution during that timeframe.
MJ
January 7, 2009 at 1:34 pm
We also experienced heavy usage on a server when running an specific service. We re-configured paging on the server and moved the service to another drive.
This helped tremendously with time.
The paging change really helped a stored procedure that was taking days to run and shrunk it to 4mins
January 7, 2009 at 1:35 pm
I forgot to mention that we also allocated the memory to use more than 2gb on the sql server
January 7, 2009 at 2:35 pm
We have similar issues and have determined alot of the problem is the code running against the server. Poor code = poor performance.
January 7, 2009 at 2:38 pm
You should profiler and find the offending query!
* Noel
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply