Tag Info

New answers tagged

8

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 ...


2

No. CXPACKET is caused by parallel processes running on the SQL Server instance. More info here



Top 50 recent answers are included