Preskočiť na obsah
Skript

Wait stats – na čo server čaká

Kumulatívne čakania od reštartu bez benígnych (idle) typov.

#dmv #tuning #waits
wait-stats-na-co-server-caka.sql 18 riadkov · T-SQL
Parametre skriptu doplň a kopíruj hotový skript
SELECT TOP (15)
        wait_type,
        wait_time_ms / 1000.0                     AS wait_s,
        (wait_time_ms - signal_wait_time_ms) / 1000.0 AS resource_s,
        signal_wait_time_ms / 1000.0              AS signal_s,
        waiting_tasks_count,
        CAST(100.0 * wait_time_ms / SUM(wait_time_ms) OVER () AS decimal(5,2)) AS pct
FROM    sys.dm_os_wait_stats
WHERE   waiting_tasks_count > 0
  AND   wait_type NOT IN (
        'BROKER_EVENTHANDLER','BROKER_RECEIVE_WAITFOR','BROKER_TASK_STOP','BROKER_TO_FLUSH','BROKER_TRANSMITTER',
        'CHECKPOINT_QUEUE','CLR_AUTO_EVENT','CLR_MANUAL_EVENT','DIRTY_PAGE_POLL','DISPATCHER_QUEUE_SEMAPHORE',
        'FT_IFTS_SCHEDULER_IDLE_WAIT','HADR_FILESTREAM_IOMGR_IOCOMPLETION','LAZYWRITER_SLEEP','LOGMGR_QUEUE',
        'ONDEMAND_TASK_QUEUE','REQUEST_FOR_DEADLOCK_SEARCH','RESOURCE_QUEUE','SLEEP_TASK','SLEEP_SYSTEMTASK',
        'SP_SERVER_DIAGNOSTICS_SLEEP','SQLTRACE_BUFFER_FLUSH','SQLTRACE_INCREMENTAL_FLUSH_SLEEP','WAITFOR',
        'XE_DISPATCHER_WAIT','XE_TIMER_EVENT','QDS_PERSIST_TASK_MAIN_LOOP_SLEEP','QDS_ASYNC_QUEUE',
        'QDS_CLEANUP_STALE_QUERIES_TASK_MAIN_LOOP_SLEEP','WAIT_XTP_OFFLINE_CKPT_NEW_LOG')
ORDER BY wait_time_ms DESC;