Every time we talk about deadlock, you will see DBA frowning on this topic. DBA believes that Developers are creating the deadlocks and developers believe that DBA’s should be taking care of the deadlocks. Essentially, it is such a subject which requires DBA and Developers to work together to resolve the issue.
SQL SERVER – How to get historical deadlock Information from System Health Extended Events?
Let me start off by asking a simple question. How many of you have seen this error about historical deadlock information earlier?
SQL SERVER – What is Deadlock Scheduler? How to Reproduce it?
If you have come on this page by internet search, then you must have seen below error in the ERRORLOG which is about deadlock scheduler.