garyblack

Yes I have seen this template, I'm in the process of playing with it myself.

In that case you could just call a script to restart that specific service using sc or powershell

Its worth noting however that it doesn't provide any backlog statistics and there are a couple of monitors which report on things such as "Staging Space in Use" but you will need to modify them to include the GUID which is present in perfmon.

I believe the agent is designed to monitor itself and the features you are looking for sound like an additional poller. Another way to achieve what you are looking to do would be to write some powershell scripts to get various health stats from the database server. To get a complete picture though would most likely be a…

Personally I think it makes more sense to use groups for this purpose. I.E Group for each customer and then a subgroup within that for the applications, you can then have multiple servers in multiple groups.

You'll need to use the alert manager to create this Settings > All Settings > Manage Alerts Add a new alert and then configure it to look something like this;