Al's BrainDump

RSS

Navigation





Quick Search
»
Advanced Search »

PoweredBy

Table of Contents [Hide/Show]


         CXPACKET


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

ScrewTurn Wiki version 3.0.5.600. Some of the icons created by FamFamFam.