This is a dedicated watch page for a single video.
Identifying blocking problem can be troublesome as they can be sporadic in nature. There is a DMV called sys.dm_tran_locks , which can be joined with sys.dm_exec_requests in order to provide further information on locks that each session is holding. Which are typical blocking problems? (Select two)