How to identify if dead locks exist on a database?  Topic is solved

Support for Microsoft SQL Server in the context of Jiwa installations.

How to identify if dead locks exist on a database?  Topic is solved

Postby renes » Tue Jun 02, 2015 9:32 am

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
02-06-2015 8-27-28 AM.png
Location of All Blocking Transactions report
02-06-2015 8-27-28 AM.png (21.26 KiB) Viewed 3880 times
renes
Occasional Contributor
Occasional Contributor
 
Posts: 11
Joined: Tue Jan 28, 2014 3:29 pm
Topics Solved: 2

Return to Microsoft SQL Server

Who is online

Users browsing this forum: No registered users and 1 guest

cron