cxpacket trong SQL Server

Here is the two-quick script which helps to resolve these issues:

Change MAXDOP at Server Level

EXEC sys.sp_configure N'max degree of parallelism', N'1'GORECONFIGURE WITH OVERRIDE
GO

Run Query with all the CPU (using parallelism)

USE AdventureWorks
GOSELECT *FROM Sales.SalesOrderDetailORDER BY ProductIDOPTION (MAXDOP 0)GO

http://blog.sqlauthority.com/2010/11/13/sql-server-reducing-cxpacket-wait-stats-for-high-transactional-database/
http://blog.idera.com/sql-server/performance-and-monitoring/cxpacket-what/