Ожидания по серверу
Вкладка предназначена для анализа состояния сервера.
Топ 10 ожиданий на сервере (сортировка по суммарной длительности ожиданий в %)
Диаграмма отражает ТОП 10 ожиданий на сервере.
Сервер MS SQL регистрирует много типов ожиданий, часть из которых не являются проблемами и не требуют анализа. Такие типы ожиданий исключаются из вывода графика.
Ожидания исключаемые из вывода
'BROKER_EVENTHANDLER'
'BROKER_RECEIVE_WAITFOR'
'BROKER_TASK_STOP'
'BROKER_TO_FLUSH'
'BROKER_TRANSMITTER'
'CHECKPOINT_QUEUE'
'CHKPT'
'CLR_AUTO_EVENT'
'CLR_MANUAL_EVENT'
'CLR_SEMAPHORE'
'DBMIRROR_DBM_EVENT'
'DBMIRROR_EVENTS_QUEUE'
'DBMIRROR_WORKER_QUEUE'
'DBMIRRORING_CMD'
'DIRTY_PAGE_POLL'
'DISPATCHER_QUEUE_SEMAPHORE'
'EXECSYNC'
'FSAGENT'
'FT_IFTS_SCHEDULER_IDLE_WAIT'
'FT_IFTSHC_MUTEX'
'HADR_CLUSAPI_CALL'
'HADR_FILESTREAM_IOMGR_IOCOMPLETION'
'HADR_LOGCAPTURE_WAIT'
'HADR_NOTIFICATION_DEQUEUE'
'HADR_TIMER_TASK'
'HADR_WORK_QUEUE'
'KSOURCE_WAKEUP'
'LAZYWRITER_SLEEP'
'LOGMGR_QUEUE'
'MEMORY_ALLOCATION_EXT'
'ONDEMAND_TASK_QUEUE'
'PREEMPTIVE_XE_GETTARGETSTATE'
'PWAIT_ALL_COMPONENTS_INITIALIZED'
'PWAIT_DIRECTLOGCONSUMER_GETNEXT'
'QDS_PERSIST_TASK_MAIN_LOOP_SLEEP'
'QDS_ASYNC_QUEUE'
'QDS_CLEANUP_STALE_QUERIES_TASK_MAIN_LOOP_SLEEP'
'QDS_SHUTDOWN_QUEUE'
'REDO_THREAD_PENDING_WORK'
'REQUEST_FOR_DEADLOCK_SEARCH'
'RESOURCE_QUEUE'
'SERVER_IDLE_CHECK'
'SLEEP_BPOOL_FLUSH'
'SLEEP_DBSTARTUP'
'SLEEP_DCOMSTARTUP'
'SLEEP_MASTERDBREADY'
'SLEEP_MASTERMDREADY'
'SLEEP_MASTERUPGRADED'
'SLEEP_MSDBSTARTUP'
'SLEEP_SYSTEMTASK'
'SLEEP_TASK'
'SLEEP_TEMPDBSTARTUP'
'SNI_HTTP_ACCEPT'
'SP_SERVER_DIAGNOSTICS_SLEEP'
'SQLTRACE_BUFFER_FLUSH'
'SQLTRACE_INCREMENTAL_FLUSH_SLEEP'
'SQLTRACE_WAIT_ENTRIES'
'WAIT_FOR_RESULTS'
'WAITFOR'
'WAITFOR_TASKSHUTDOWN'
'WAIT_XTP_RECOVERY'
'WAIT_XTP_HOST_WAIT'
'WAIT_XTP_OFFLINE_CKPT_NEW_LOG'
'WAIT_XTP_CKPT_CLOSE'
'XE_DISPATCHER_JOIN'
'XE_DISPATCHER_WAIT'
'XE_TIMER_EVENT'
'SOS_WORK_DISPATCHER'
'CXCONSUMER'
'BROKER_RECEIVE_WAITFOR'
'BROKER_TASK_STOP'
'BROKER_TO_FLUSH'
'BROKER_TRANSMITTER'
'CHECKPOINT_QUEUE'
'CHKPT'
'CLR_AUTO_EVENT'
'CLR_MANUAL_EVENT'
'CLR_SEMAPHORE'
'DBMIRROR_DBM_EVENT'
'DBMIRROR_EVENTS_QUEUE'
'DBMIRROR_WORKER_QUEUE'
'DBMIRRORING_CMD'
'DIRTY_PAGE_POLL'
'DISPATCHER_QUEUE_SEMAPHORE'
'EXECSYNC'
'FSAGENT'
'FT_IFTS_SCHEDULER_IDLE_WAIT'
'FT_IFTSHC_MUTEX'
'HADR_CLUSAPI_CALL'
'HADR_FILESTREAM_IOMGR_IOCOMPLETION'
'HADR_LOGCAPTURE_WAIT'
'HADR_NOTIFICATION_DEQUEUE'
'HADR_TIMER_TASK'
'HADR_WORK_QUEUE'
'KSOURCE_WAKEUP'
'LAZYWRITER_SLEEP'
'LOGMGR_QUEUE'
'MEMORY_ALLOCATION_EXT'
'ONDEMAND_TASK_QUEUE'
'PREEMPTIVE_XE_GETTARGETSTATE'
'PWAIT_ALL_COMPONENTS_INITIALIZED'
'PWAIT_DIRECTLOGCONSUMER_GETNEXT'
'QDS_PERSIST_TASK_MAIN_LOOP_SLEEP'
'QDS_ASYNC_QUEUE'
'QDS_CLEANUP_STALE_QUERIES_TASK_MAIN_LOOP_SLEEP'
'QDS_SHUTDOWN_QUEUE'
'REDO_THREAD_PENDING_WORK'
'REQUEST_FOR_DEADLOCK_SEARCH'
'RESOURCE_QUEUE'
'SERVER_IDLE_CHECK'
'SLEEP_BPOOL_FLUSH'
'SLEEP_DBSTARTUP'
'SLEEP_DCOMSTARTUP'
'SLEEP_MASTERDBREADY'
'SLEEP_MASTERMDREADY'
'SLEEP_MASTERUPGRADED'
'SLEEP_MSDBSTARTUP'
'SLEEP_SYSTEMTASK'
'SLEEP_TASK'
'SLEEP_TEMPDBSTARTUP'
'SNI_HTTP_ACCEPT'
'SP_SERVER_DIAGNOSTICS_SLEEP'
'SQLTRACE_BUFFER_FLUSH'
'SQLTRACE_INCREMENTAL_FLUSH_SLEEP'
'SQLTRACE_WAIT_ENTRIES'
'WAIT_FOR_RESULTS'
'WAITFOR'
'WAITFOR_TASKSHUTDOWN'
'WAIT_XTP_RECOVERY'
'WAIT_XTP_HOST_WAIT'
'WAIT_XTP_OFFLINE_CKPT_NEW_LOG'
'WAIT_XTP_CKPT_CLOSE'
'XE_DISPATCHER_JOIN'
'XE_DISPATCHER_WAIT'
'XE_TIMER_EVENT'
'SOS_WORK_DISPATCHER'
'CXCONSUMER'