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