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.
Let me start off by asking a simple question. How many of you have seen this error about historical deadlock information earlier?
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.