What are Lock Waits and Blocking Chains? How do you debug them?

Mid MS SQL

Answer

Blocking occurs when a session holds a lock required by another. Debugging tools include:

  • sp_whoisactive
  • sys.dm_exec_requests
  • Extended events
  • Activity Monitor

Want to bookmark, take notes, or join discussions?

Sign in to access all features and personalize your learning experience.

Sign In Create Account

Source: SugharaIQ

Ready to level up? Start Practice