Answer
Blocking is identified using:
- sys.dm_exec_requests – blocking_session_id
- sys.dm_os_waiting_tasks – wait chains
- Activity Monitor – high-level visualization
Blocking chains often originate from a long-running transaction holding critical locks.
Blocking is identified using:
Blocking chains often originate from a long-running transaction holding critical locks.
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ