Traditionally, trace flags 1204 or 1222 are used to write information about deadlock events to the SQL Server log. But since SQL Server 2012, there is a default Extended Event session running called system_health that can be used instead. Extended … Read more →
Deadlocks in SQL Server can be difficult to avoid completely, but there are some basic rules that can help in avoiding them. This blog post will cover the basics of deadlocking in SQL Server.