Deadlocking is a common problem that can occur in an SQL Server database. This is like blocking. But instead of being blocked forever, SQL Server chooses one session as the deadlock victim and rolls it back so the other process can continue.
SQL Diagnostic Manager allows you to drill into the deadlock to find the sessions that are involved as well as the code that is causing the problem for quick resolution. You can also see a history of deadlocks like we saw for blocking. This lets you determine if there is a pattern with particular processes and also how frequently deadlocks occur.
For more information, please refer to the solution brief “Keep your SQL Servers running smoothly with SQL Diagnostic Manager” by Greg Robidoux from MSSQLTips.