DPA Monitor and Heartbeat Status

This application monitor template is applied to the Orion SQL server and runs a sql query to determine if the DPA service is running and a separate sql query to determine if any one DPA monitor is off on an instance in DPA.  An alert can be easily generated from this and if you use the user notes within the component monitor as support notes; you can insert the wildcard ${N=SwisEntity;M=ComponentAlert.UserNotes} into the email message and it will display specific support instructions for that component monitor.