Monitor SQL Server?

[omegadigital]

Is it possible to monitor SQL Server performance as well using the api?

I know it's possible to set this up through C#/WCF as a service but not sure whether the api could handle this.

Thanks

Bert

[Cptrico]

Hi Bert,

Yes it is possible. create a plugin that monitors the SQL server and run it every 15 seconds and get a notification when any threshold has been violated or the communication is lost.

Have a look at the example plugins from PCM to get an ideer on how easily it is to work with.

Best regards

Johnni

[Marius]

You can monitor the SQL Server using the performance counters page - you simply add the SQL counters you want to be monitored.

As well, you can define rules based on various SQL counters and get notified when the rule condition is true.

[marinhd]

Yes. As simple as mobilepcmonitor looks. It can become quite complex in what it is capable of doing!!!! I also recommend spending some time playing with the performance counters...