October 1, 2006 at 10:45 pm
Hi,
Our Server CPU is Going 100% usuage all of sudden from last 2 days. Our Current DB size is 70GB. It also contain 5-6 Very Huge Table. Configuraation is as below:
CPU: 4
Memory: 8GB
Service Pack : SQL2000/ SP4
PAE/3GB Enabled in boot.ini.
Pls. suggests. What could be the Ideal cause.
Thanks
October 2, 2006 at 1:57 am
Well to be honest I'd lay my hands on an eval of sql diagnostic manager and point it at my server. I think by the time you've gone through all the manual stuff and suggestions you might as well use a proper tool for the job.
I'd actually make sure it's sql using all the cpu mind - use perfmon or task manager. Prime culprits for high cpu include almost any third party backup agent/tool, any achiving process, rar, winzip etc. any antivirus. Look also for executing msi's, most tools that apply updates or do inventorys will often be a problem. Altiris when executing an inventory can bring a server to its kness and I've seen it misconfigured and suddenly apply hot fixes in the middle of the day.
Disable all non-essential services , altiris, auto updates, anti virus, 3rd party monitoring tools, backup agents. Kill any process you don't recognise ( use google or similar to identify processes if you're not sure )
use sp_who2 active to monitor your executing threads to find the guilty, then track the executing sql with profiler.
Check disk subsystem for fragmentation, high usage, long i/o completion times
Essentially eliminate all the non-sql! btw I'd do a quick check on active processes on the sql server first looking for that query from hell!!
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
October 3, 2006 at 8:44 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply