April 25, 2013 at 8:17 am
Hi,
Can anyone please confirm does CXpacket waits causes high CPU...
because we got high cpu alerts yesterday on my environment...when i look into monitoring tool...i can see a spid (stored proc which does delete) and in suspended mode.
Wait type : CXPacket
Wait time : 893575
physical io : 968
Server Specs :
sql 2008 sp2, standard edition 64-bit
windows server 2008 R2 standard edition
Processors : 2
Memory : 12 GB
Please let me know if you need any details
Thanks in advance
April 25, 2013 at 8:26 am
You have only 2 processor?. In OLTP, this wait is not typical, but in OLAP.
Find out the query which is running in parallelism and taking high cpu usage.
http://www.mssqltips.com/sqlservertip/2316/how-to-identify-sql-server-cpu-bottlenecks/
April 25, 2013 at 9:03 am
yeah Stored proc is causing it i guess...because we got the high CPU alerts from 11.08 to 11.38 Pm yesterday and this stored proc is in suspended mode from 11:00 to 11:38 PM....
April 25, 2013 at 11:12 am
No. CXPacket waits are an indication that you have a parallel process that is waiting. It can be an indication of high CPU use, but it's not the root cause. It's whatever queries you're running and whatever they're doing.
"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
April 25, 2013 at 12:54 pm
I would suggest that you figure out the offending query and tune it.
April 25, 2013 at 1:40 pm
Have a read through chapter 3 of http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/
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
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply