To watch for blocking that comes from a specific machine in your environment, this alert can help do that. To create it, create a Custom SQL - Single Numeric alert and make it look similar to this example. Paste in the contents of the attached script into the SQL Statement text box.
The following placeholders are automatically passed into the SQL statement when the alert executes:
- #FREQUENCY# - the number of minutes chosen for the execution interval. This query looks back in the repository this number of minutes.
- #DBID# - each instance has its own set of tables in the DPA repository, so this tells the query which tables to go use
