• This is what i get from the sys.dm_os_waiting_tasks. What do i do from here. pls help.

    wait_duration_ms wait_type

    -------------------- ------------------------------------------------------------

    2688 LOGMGR_QUEUE

    2047 BROKER_RECEIVE_WAITFOR

    1125 REQUEST_FOR_DEADLOCK_SEARCH

    54875 CXPACKET

    54875 CXPACKET

    54875 CXPACKET

    54875 CXPACKET

    54875 CXPACKET

    54875 CXPACKET

    54875 CXPACKET

    63 PAGEIOLATCH_SH

    0 OLEDB

    366170563 KSOURCE_WAKEUP

    110 PAGEIOLATCH_SH

    354438 CHECKPOINT_QUEUE

    0 PAGEIOLATCH_SH

    366174656 ONDEMAND_TASK_QUEUE

    16 PAGEIOLATCH_SH

    1797 SQLTRACE_BUFFER_FLUSH

    366173219 BROKER_TRANSMITTER

    63 PAGEIOLATCH_SH

    366108391 BROKER_EVENTHANDLER

    3406 BROKER_TASK_STOP

    16 PAGEIOLATCH_SH

    375 LAZYWRITER_SLEEP

    366173219 BROKER_TRANSMITTER

    203 PAGEIOLATCH_SH