SELECT TOP 10 wait_type, waiting_tasks_count AS tasks, wait_time_ms, max_wait_time_ms AS max_wait,signal_wait_time_ms AS signal
FROM sys.dm_os_wait_stats
ORDER BY wait_time_ms DESC;

SQLTRACE_BUFFER_FLUSH 193 772000 4000 0
LAZYWRITER_SLEEP 774 770906 1000 0
MISCELLANEOUS 154 45718 296 0
ASYNC_NETWORK_IO 330 250 187 15
MSQL_XP 25 78 15 0
PAGEIOLATCH_SH 3 31 15 0
LCK_M_SIX 0 0 0 0
LCK_M_SIU 0 0 0 0
LCK_M_IX 0 0 0 0
LCK_M_IU 0 0 0 0