I came across a database today that was doing a lot of inserting onto a table. It was taking an exceptionally long time. On clearing the Wait Stats, the CXPACKET wait type kept coming to the top of the list. Generally CXPACKET is considered a secondary wait type, caused by some other issue. Im having trouble identifying what this main issue is though.
-The query is using a Parallel plan, utilizing most of the processors.
-The table being inserted into has no indexes of any type, I guess to speed up insert.
-Processor affinity is set to use 7 procs for processing & 1 for IO.
The job has complete, and I cant run it again so im a bit stuck with regard to reproducing and nailing down the cause of the issue, but any speculation would be much appreciated.