Collecting Additional Metrics at Time of Alert

by Oct 9, 2015

Hello. Is there a way to collect additional metrics at the time an alert is triggered? For example, when we receive a high CPU alert I’d like to have DM execute something that sends us say the top 10 processes using CPU time. I’m not sure if it would be a PoweShell script or SQL code, or even a SQL Agent job that would then be kicked off to gather and email the stats. I know that DM can execute an external program but I assume that will execute on the DM server and not against the target (alerted) server.

Any help or advice would be appreciated.