MSSQL Cluster Monitoring

[ecarrasq]

Is there a "How To" and/or plugin to monitor a MS SQL Cluster?

I looked in the Nagios>Exchange>Plugins, but didn't have any luck. Though if there is one there, I have not seen it/used. Any help will be appreciated.

Thanks

[yancy]

ecarrasq,

Are you looking to check the cluster or the MSSQL clustered database?

Here is a plugin that monitors a microsoft cluster
http://exchange.nagios.org/directory/Pl ... pt/details

There are many MSSQL plugins on Nagios exchange.

Regards,

-Yancy

[ecarrasq]

Perfect!

I must have missed this one, as I saw all the other MSSQL plugins.

I'll reply back if I run into any issues.

Thank you!

[yancy]

ecarrasq,

No problem. Glad you found the plugin you needed.

-Yancy

[ecarrasq]

UNKNOWN: No handler for that command

I followed these instructions, but getting the above error:

1. add the following line to your NSC.INI [NRPE Handlers]:

<---- there is no NRPE Handlers section in the NSC.ini file, but there is a NRPE Client Handlers section

check_mscs=cscript.exe //T:30 //NoLogo scripts\check_microsoft_cluster.vbs $ARG1$ $ARG2$

2. copy "check_microsoft_cluster.vbs" into "scripts\" folder at each node.

3. Point this check to the corresponding clustered ressource (type "Cluster Name" & "Cluster IP Address"), not to a single node (please look at section "testing & debugging").

4. Define Command:

command_name check_mscs_nrpe

command_line $USER1$/check_nrpe -H $HOSTADDRESS$ -p 5666 -t 30 -c check_mscs -a "$ARG1$" "$ARG2$"

5. Service Definition:
use = generic-service
host_name = <MS Cluster>
service_description = MSCS Resources
process_perf_data = 0
check_command = check_mscs_nrpe!CLRESP

6. INFO:
The plugin will accept the following parameters: ($ARG1$ and $ARG2$)

check_microsoft_cluster.vbs CLRES|CLRESP [ressource list]
check_microsoft_cluster.vbs CLNODE [node list]

[slansing]

What does the nagios console report after you run the following:

Code: Select all

/usr/local/nagios/libexec/check_nrpe -H xxx.xx.xx.xx -t 30 -c check_mscs -a "xxxx" "xxxx"

NOTE: Replace the x's with your information "Host name, Resources, Nodes"


I was able to get it functioning on my system properly.

[abrist]

UNKNOWN: No handler for that command

Is there any other information in the logs?

You may want to enable debug logging in log section of your nsc.ini (starts at line 85). Do that and then post the more verbose error logs.

[yancy]

ecarrasq,

I looked over your NSC.ini file and you'll want to remove check_mscs line from [NRPE Client Handlers]

it should only be defined in [External Scripts]

Also, since this script takes arguments, enable arguments in [external script]

Code: Select all

 allow_arguments=1 

that should do the trick.

Regards,

-Yancy

[ecarrasq]

Just revisiting this topic, as I was not able to work on it previously.

What level of access (permissions) should the active directory account/or local account used to log into the MSSQL server have in order for this to work?

Would the scripts being run on the MSSQL server need specific permissions?

Thank you,
Eddie

[lmiltchev]

This is a 3rd party plugin, so I would recommend asking the developer for clarification on this. You can post your question here:

Code: Select all

http://exchange.nagios.org/directory/Plugins/Clustering-and-High-2DAvailability/Check-Microsoft-Cluster-Server-via-vbscript/details