• Jonathan Kehayias has a query on this blog post[/url] that identifies parallel plans in the cache which can help you start tuning the SQL that might be causing the CXPACKET waits.