• I look forward to it 🙂

    Oddly it wasnt that the numbers were different. It was that the waits were entirely different. There wasn't any overlap between the two scripts. Your script looked like this:

    WRITELOG7168331141587429

    CXPACKET1727229412899940

    ASYNC_NETWORK_IO20313663974649

    PAGEIOLATCH_SH37109653626942

    PAGEIOLATCH_EX688979436225

    ASYNC_IO_COMPLETION299297143

    IO_COMPLETION415738212294

    PAGELATCH_EX23683964209939

    SOS_SCHEDULER_YIELD5274174136505

    LATCH_EX23642071269

    Glenn's looked like this:

    wait_typewait_time_spctrunning_pct

    SQLTRACE_INCREMENTAL_FLUSH_SLEEP1490310.3938.2838.28

    BROKER_EVENTHANDLER1434896.1336.8675.14

    ONDEMAND_TASK_QUEUE887224.0422.7997.94

    Notice no overlap in wait types...

    Both scripts are awesome in their own way and I look forward to all of the inovation and inginuity that goes into each person's version.

    Best,

    Tony