Page History
...
SQL Server chooses one or more deadlock to terminate so that processing can continue.
Resolve deadlocks
When a Deadlock Alert occurs, check the Alerts view in SQLdm SQL Diagnostic Manager and select a deadlock alert. The SPID, Hostname, Login Name, Client Application, and Database are listed.
For more information, select Show Deadlock Details. This information helps with diagnosing the problem application and includes the option to export deadlock data to view in SQL Server Management Studio or SQL Server Profiler.
Tip |
---|
Create an alert response bundle with the Deadlock alert and related alerts. |
...
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
...
For additional information, see Create alert response bundles. |
...