• I have filtered it only those where wait time is more than 1hr. What is the probable cause of slow performance.

    wait_typewaiting_tasks_countwait_time_msmax_wait_time_mssignal_wait_time_ms
    SLEEP_SYSTEMTASK1997420313859453681388802
    DIRTY_PAGE_POLL31160331349282461183
    LOGMGR_QUEUE25268131348760663566
    REQUEST_FOR_DEADLOCK_SEARCH627031347932519831347932
    LAZYWRITER_SLEEP331253134634512601881
    SQLTRACE_INCREMENTAL_FLUSH_SLEEP78363134292240302
    XE_TIMER_EVENT809531334544504931334544
    QDS_SHUTDOWN_QUEUE523313205826000626
    XE_DISPATCHER_WAIT262313109981200250
    HADR_FILESTREAM_IOMGR_IOCOMPLETION62492313081806274081
    SP_SERVER_DIAGNOSTICS_SLEEP655123120005030000331200050
    FT_IFTS_SCHEDULER_IDLE_WAIT5183102050860038106
    CHECKPOINT_QUEUE1592688463711692551272
    CLR_AUTO_EVENT9246791901233862012
    ASYNC_NETWORK_IO575901574627420808662
    SLEEP_TASK739401565687411074566
    BROKER_TO_FLUSH15274156551871102922