Query on sql server cluster monitoring

[scottwilkerson]

If you go to the service status detail page for this service what is displayed?

Looking at this again, I'm not positive that this plugin conforms to the threshold standards, lets also try with $ARG1$ as

Code: Select all

-U 'sa' -P 'my sa pwd' -p myport --deadlocks --warning 5 --critical 10

[maxwellmiranda]

how do i monitor a non default instance on sql server
i am trying the below query at the command line

./check_mssql_database.py -H 'usmasql1.bose.com' -U 'nagios' -P 'nagios' -I USMASQL1\USMASQL1 -T 'master' -p 1433 --time2connect --warning 1 --critical 5


my sql instance is USMASQL1
and the server name is USMASQL1


the above command doesnot work

[slansing]

What do you get as output from the Nagios server's command line when running that check against the MSSQL server? Does it work with just one instance name? "USMASQL1"

[maxwellmiranda]

i get the message " cannot connect to the sql server"

i tried with just the instance name but am getting the same error

[scottwilkerson]

If you are monitoring an instance you need to remove the -p 1433 and if you have a \ you will need to escape it

Code: Select all

./check_mssql_database.py -H 'usmasql1.bose.com' -U 'nagios' -P 'nagios' -I USMASQL1\\USMASQL1 -T 'master' --time2connect --warning 1 --critical 5

On some servers just

Code: Select all

./check_mssql_database.py -H 'usmasql1.bose.com' -U 'nagios' -P 'nagios' -I USMASQL1 -T 'master' --time2connect --warning 1 --critical 5