Diagnosing deadlocks in SQL Server with Extended Events
Error 1205 again? Pull the deadlock graph from the system_health session, read it like a DBA and fix the access pattern that causes it.
#concurrency#locking#troubleshooting
Tanishk · 10 min
Topic
Error 1205 again? Pull the deadlock graph from the system_health session, read it like a DBA and fix the access pattern that causes it.
#concurrency#locking#troubleshooting
What each isolation level protects you from, what it costs, and why so many teams switch on READ_COMMITTED_SNAPSHOT.
#concurrency#locking#transactions