Is there an alert in DPA that will alert when a deadlock occurs?
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
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.
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 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.