cancel
Showing results for 
Search instead for 
Did you mean: 
melissa306
Level 8

How do I find deadlocks?

Is there an alert in DPA that will alert when a deadlock occurs?

15 Replies
jaminsql
Level 12

Re: How do I find deadlocks?

There is not one for deadlocks built in to DPA. This is a custom alert for SQL server by mandevil Custom Alert - Deadlocks There is also a custom metric so you can just have a chart displaying deadlocks. Custom Metric - Deadlocks

m60freeman
Level 12

Re: How do I find deadlocks?

1) What if I'd like to receive an email for each deadlock that includes the XML for the deadlock in the body of the alert email (or as an attachment)?

2) How can I create a chart from a custom metric like the one for deadlocks?

0 Kudos
jaminsql
Level 12

Re: How do I find deadlocks?

Mark,

This alert is pulling from sys.dm_xe_session_targets looking for when a deadlock happens but, is not saving the XML anywhere and there isn't a way to attach a file to the alert emails so I don't think that this is possible in DPA currently. Please add this idea as a feature request Database Performance Analyzer Feature Requests

There is a chart made on any custom metric when you create them. To create the metric, click on Options > Custom Resource Metrics. The charts for these can be customized by editing some XML. This gets technical enough that it might be best  to explain in a support request. 



0 Kudos
kdooley
Level 8

Re: How do I find deadlocks?

I am very disappointed to learn this as the product I just moved from did this very well.

0 Kudos
m60freeman
Level 12

Re: How do I find deadlocks?

What product were you using?

0 Kudos
mandevil
Level 14

Re: How do I find deadlocks?

There's a way to augment the deadlock alert.  Since we can parse the error log, (make sure you set your trace flags appropriately) you can also configure an alert to send you some of the text from the error log.  It won't be the complete stack, will point you right to where to find it in the error log.

0 Kudos
kdooley
Level 8

Re: How do I find deadlocks?

Spotlight reported the deadlocks with the information about the processes that deadlocked.

0 Kudos
mandevil
Level 14

Re: How do I find deadlocks?

I love the idea - feature request?  See jaminsql's comment up above.

0 Kudos
m60freeman
Level 12

Re: How do I find deadlocks?