Do we need to install Pre-requisites for monitoring MS SQL

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
abrist
Red Shirt
Posts: 8334
Joined: Thu Nov 15, 2012 1:20 pm

Re: Do we need to install Pre-requisites for monitoring MS S

Post by abrist »

I believe that was the suggestion given by Spencer.
sreinhardt wrote:-Wv50: and -Cv100:
Will equate to 50+ and 100+.
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
MSPk
Posts: 317
Joined: Fri Aug 24, 2012 12:03 am

Re: Do we need to install Pre-requisites for monitoring MS S

Post by MSPk »

I have tried it but it doesnt work...!!!!
abrist
Red Shirt
Posts: 8334
Joined: Thu Nov 15, 2012 1:20 pm

Re: Do we need to install Pre-requisites for monitoring MS S

Post by abrist »

What was the full command that you tried? The location of the "colon"s are important.
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
MSPk
Posts: 317
Joined: Fri Aug 24, 2012 12:03 am

Re: Do we need to install Pre-requisites for monitoring MS S

Post by MSPk »

DB_connections=scripts\check_mssql_nt.exe /H:Instancename /CHK_CONNECTIONCOUNT -Wv50: -Cv100:

Output : MSSQL OK - 60 connections in 0.24 seconds
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: Do we need to install Pre-requisites for monitoring MS S

Post by scottwilkerson »

Plugin help is pretty poor on this plugin as it mixes items up in the examples... I would try

Code: Select all

DB_connections=scripts\check_mssql_nt.exe /H:Instancename /CHK_CONNECTIONCOUNT /Wv:50 /Cv:100
or

Code: Select all

DB_connections=scripts\check_mssql_nt.exe /H:Instancename /CHK_CONNECTIONCOUNT -Wv:50 -Cv:100
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
Locked