I have filtered it only those where wait time is more than 1hr. What is the probable cause of slow performance.
wait_type | waiting_tasks_count | wait_time_ms | max_wait_time_ms | signal_wait_time_ms |
SLEEP_SYSTEMTASK | 1997420 | 31385945 | 36813 | 88802 |
DIRTY_PAGE_POLL | 311603 | 31349282 | 461 | 183 |
LOGMGR_QUEUE | 252681 | 31348760 | 663 | 566 |
REQUEST_FOR_DEADLOCK_SEARCH | 6270 | 31347932 | 5198 | 31347932 |
LAZYWRITER_SLEEP | 33125 | 31346345 | 1260 | 1881 |
SQLTRACE_INCREMENTAL_FLUSH_SLEEP | 7836 | 31342922 | 4030 | 2 |
XE_TIMER_EVENT | 8095 | 31334544 | 5049 | 31334544 |
QDS_SHUTDOWN_QUEUE | 523 | 31320582 | 60006 | 26 |
XE_DISPATCHER_WAIT | 262 | 31310998 | 120025 | 0 |
HADR_FILESTREAM_IOMGR_IOCOMPLETION | 62492 | 31308180 | 627 | 4081 |
SP_SERVER_DIAGNOSTICS_SLEEP | 65512 | 31200050 | 300003 | 31200050 |
FT_IFTS_SCHEDULER_IDLE_WAIT | 518 | 31020508 | 60038 | 106 |
CHECKPOINT_QUEUE | 159 | 26884637 | 11692551 | 272 |
CLR_AUTO_EVENT | 9 | 24679190 | 12338620 | 12 |
ASYNC_NETWORK_IO | 57590 | 15746274 | 2080 | 8662 |
SLEEP_TASK | 73940 | 15656874 | 1107 | 4566 |
BROKER_TO_FLUSH | 15274 | 15655187 | 1102 | 922 |