Setting up monitoring of SQL clusters

[bosecorp]

Hi,
We have a 2 node SQL cluster and want to monitor the various SQL instances which have been set up as services. How would we be able to do this? I am attaching a document showing you the clusters.

Thanks

Issac

[ssax]

What specifically are you looking to monitor?

You should be able to go to Configure > Configuration Wizards > MSSQL Database and put in the VIP (Virtual IP) of the cluster and then specify the instance, will that work for you?

[sify_nagios]

Hi Team,

I think ISSAC is trying to ask about the MSSQL Cluster migration monitoring.
I want to monitor which node MSSQL is running and get alert whenever cluster migrated to another node.

If Issac is not meant i said. Consider this as a fresh request and please respond anyway

Thanks in advance
Srini

[ssax]

More than likely the best option for that would be to check the event logs on the machines for what you're looking for based on the research I've done, you could write a powershell script to gather alternate data and run it via NRPE if needed.