Page 1 of 1
Setting up monitoring of SQL clusters
Posted: Thu Jul 21, 2016 12:45 pm
by 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
Re: Setting up monitoring of SQL clusters
Posted: Thu Jul 21, 2016 1:35 pm
by 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?
Re: Setting up monitoring of SQL clusters
Posted: Fri Jul 22, 2016 2:01 am
by 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
Re: Setting up monitoring of SQL clusters
Posted: Fri Jul 22, 2016 12:04 pm
by 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.