September 16, 2009 at 8:15 am
Hi experts,
One of our live server is showing high CPU utilisation.Why this is so?Please help
I am attaching a screenshot of activity monitor.
Thanks in ADVANCE
J.K
September 16, 2009 at 8:45 am
Katmai Stratovolcano (9/16/2009)
Hi experts,One of our live server is showing high CPU utilisation.Why this is so?Please help
I am attaching a screenshot of activity monitor.
Thanks in ADVANCE
J.K
just as a side note, I can see your server is on Service pack 4, there are additional upgrades you might want to do.
http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
Regarding your question.
WRITELOG
This waittype indicates that the SPID is waiting for a transaction log I/O request to complete. This waittype may also indicate a possible disk bottleneck.
you have a lot of
CXPACKET
These waittypes are all involved in parallel query execution. These waittypes indicate that the SPID is waiting on a parallel process to complete or start.
I would check this activity and see what it is doing, hard to guess without knowing what else is going on, you might have a sp which does parallel queries perhaps.
Put profiler on and have a look if you can.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 16, 2009 at 9:23 am
You should evaluate Wait Stats. Andrew Kelly had an excellent little article in SQL Server Magazine recently. The Instanct Doc ID was 102111.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply