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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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