We have a DPA trial installed and I was looking into alerting capabilities. Is there a way to send an email alert when a deadlock is detected? I'm seeing block wait times, but not deadlocks. Am I missing it?
Yes, there is an alert just for deadlocks. It's in the Administrative group called SQL Server Deadlocks.
There is also a "Total Blocking Wait Time" alert under Wait Time Category.
You can also set up custom alerts. Custom Metrics and Custom Alerts can be setup to query either the monitored database or query the DPA Repository.
In Thwack for DPA, do a search to see related articles that have been submitted as well as a plethora of other custom alerts and metrics that people have setup. Some of the more relevant ones to Deadlocks:
