Is there an alert in DPA that will alert when a deadlock occurs?
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
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?
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.
I am very disappointed to learn this as the product I just moved from did this very well.
What product were you using?
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.
Done: https://thwack.solarwinds.com/ideas/4864
This is support now in DPA.
SQL Server Deadlocking – Database Deadlock | SolarWinds
Anyway to get the actual deadlock details sent when a deadlock is encountered?
Deadlock support what released in DPA 10.2, check out this post DPA 10.2 Now Available - Root Blockers, Idle Blockers and Deadlocks to see how to access deadlock data.
Hi bmrad. Thanks for the response. Is there an automated way in DPA to have the deadlock report emailed instead of having to open the deadlock summary and use the "send as E-mail" function?
