dp-300-database-admin-assoc video for identifying blocking problem can be troublesome as they can be sporadic in nature. There is a DMV called sys.dm_tran_locks
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)