DMVs

Question 1

Sys.dm_os_wait_stats

Answer 1

Cumulative statistics that tells you the length of time each wait type has executed since the last server restart. This DMV can be reset manually

Question 2

Sys.dm_os_waiting_tasks

Answer 2

This DMV shows the currently waiting session ids.

Question 3

Sys.dm_tran_locks

Answer 3

This DMV shows all the current locks. It shows you the resources that are being locked. The request status shows whether the lock is granted or it is waiting