Question: how to avoid cxpacket wait type?
Answer: The Real Way to Reduce CXPACKET Waits To do that, you have to… Learn your workload. Use SQL Server's plan cache to find the most resource-intensive queries on your system, and then analyze the costs of those queries.