Question: how to resolve cxpacket waits?
Answer: Adjust the cost threshold for parallelism. Use the MAXDOP query hint. Limit parallelism for the entire instance by setting max degree of parallelism to some number less than the total number of CPUs. For example if you have 8 processors, set max degree of parallelism to <=7.