October 15, 2009 at 9:35 am
In SQL server prod server CPU has reached 100%
SQL Server 2005 std edition 1399
SQL Server is taking 1,764,748 kb memory
Please advice
October 15, 2009 at 9:44 am
What have you done to try and troubleshoot?
Check jobs
sp_who2
blocking
long running queries
something outside of sql server consuming the processor
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 15, 2009 at 9:45 am
What exactly are you looking for? Advice on reducing the cpu usage?
Are you sure it's SQL using all the CPU time?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2009 at 9:56 am
@CirquedeSQLeil
No jobs are failed
No blockings
No long running queries
I checked perfmon counters. Pages/sec and avg disk counters reaching to 80-100 some time.
@gila master
Thanks for your reply, yes I want to reduce cpu usage, I believe SQL server is taking more memory.
October 15, 2009 at 10:00 am
In addition to failed jobs - you need to verify what jobs are running at the time the processor usage reaches 100%.
To find what is causing the problem it is a process of finding:
1. What has changed?
2. What is running (processes, queries, jobs) and eliminate variables bit by bit
3. Verifying the environment
Do you have a linked server setup on this server as well? This is another one of those variables.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 15, 2009 at 10:05 am
chk2009 (10/15/2009)
Thanks for your reply, yes I want to reduce cpu usage, I believe SQL server is taking more memory.
Find the queries that are using all the CPU. Optimise them. This may involve rewriting the query, it may involve tuning indexes, it usually involves both.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2009 at 11:05 am
Thank you -CirquedeSQLeil and Gila monster
Issue has been resolved.
One windows service is taking more memory. This service runs daily 12Pm, basically it connects to external client system it downloads ftp and decrypt file and by using bulk insert transfers data to our system. I have restarted this service and now CPU usage looks good. Thanks once again.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply