How to identify if dead locks exist on a database? 
Posted: Tue Jun 02, 2015 9:32 amSometimes 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
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 3985 times