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?
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.
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.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.