Navigation¶

• Main Page
  

• Random Page
• Create a new Page
• All Pages
• Categories
  

• Administration
• File Management
  

• Login/Logout
• Language Selection
• Your Profile
• Create Account
  

Wait Types

CXPACKET¶

• If a query is run with multiple threads, and one thread completes before the others, then SQL Server will report the wait type CXPACKET for that thread.
  

  
  select * from sys.dm_exec_query_stats 
  where total_elapsed_time < total_worker_time
  - total_worker_time is measured to the microsecond, but is accurate to the millisecond so:
  and ( ( total_worker_time – total_elapsed_time ) / execution_count ) * 1.0 > 1000 - avg difference is at least 1 ms