murthykalyani (10/31/2013)

---

I haven't comeacross CXPACKET waittype while inserting data.

Mostly sql server decides whether to execute the query on parallel threads or not, based on the estimate time the query completes i.e "cost threshold for parallelism". If sql server estimates that if the query takes more than 5 seconds then parallelism is kicked off, the session that is executing SQL will be executed on parallel threads if any of the threads yields or still executing and if other threads completed their tasks are waiting for completion of the thread that has yielded or still executing, then you will see CXPACKET waittype for threads that have completed its task and other waittype for the thread that is still executing.

Are you populating table through a query, if so please have fine tuned your query so that you don't run into issue, if you still run into issue you can suppress parallelism by calling maxdop query hint in your query and specificying value 1 so that your query runs only on one thread.