• Jonathan Kehayias has a query in this blog post[/url] that finds parallel plans in the cache so you could compare your results to his.

    Oh, also, it could be that you don't really have performance issues and that CXPACKET just happens to bubble to the top because everything else is working so well. Some wait type has to be the biggest.