This procedure, when created and executed on the DPA repository (SQL Server only), will create a temporary table and return three key resource metric indicators (CPU, Network Response Time, and Deadlocks) across all instances being monitored by DPA.
This can be used as an example of how to mine DPA's Resource Metric data to generate a global health check report across all instances DPA is monitoring.'
You could get creative and create a SQL Agent Job on the DPA repository that executes the stored procedure every two hours and then create a DPA Custom Multi-Numeric Alert that uses this temp table as a source for triggering global alerts based on the values it contains.
Note: Install the stored procedure into the DPA repository database. The procedure can easily be modified to include other performance metrics stored in the DPA repository database. You can get a list of all the Resource Metric Names for each instance by querying the CON_METRICS_#dbid table. Where the #dbid is the database ID stored in COND. You can also reference DPA Metric query collector report Detail tables. for a list of other SQL Server resource metrics available.