SQL Server クエリ待機の状況を確認する - 戦艦ゆにっき

1.select
2. wait_type as '待機の種類',
3. waiting_tasks_count as '待機数',
4. wait_time_ms as '総待機時間',
5. max_wait_time_ms as '最大待機時間',
6. signal_wait_time_ms as '準備時間'
7.from sys.dm_os_wait_stats
8.order by wait_time_ms desc