How to identify if dead locks exist on a database?

[renes]

Sometimes it is necessary to find out if some dead locks exist on a database. The user will experience this if something is running very slow what normally runs for a quick period of time only. For example reports. If they suddenly run slow and then run fast again but intermittently they go back to running slow or don't even finish, then a deadlock could be the cause.

SQL Management Studio has a standard report which can be run to identify these issues.

The report can be launched as follows:
1. Launch MS SQL Management Studio
2. Right click on the database where the issue occurs
3. Select Reports>Standard Reports>All Blocking Transactions

Location of All Blocking Transactions report

02-06-2015 8-27-28 AM.png (21.26 KiB) Viewed 7107 times