New answers tagged parallelism
When you issue a WAITFOR command, the task will start having a wait_type of WAITFOR. This is a benign wait type and can be ignored. Likewise, when this task enters the suspended state it will get off of the scheduler (processor) so it won't be taking up worker time. We can see this with a simple example: use AdventureWorks2012; go waitfor delay ...
No. CXPACKET is caused by parallel processes running on the SQL Server instance. More info here
Top 50 recent answers are included