Nagios Support Forum

returns with OK: Buffer Cache Hit Ratio is 99.9038923594%|buffer_cache_hit_ratio=99.9038923594%;90:;95;;;;

under views, service, service detail ( for the failing alert). I then selected reconfigure. In this box the command being issued is
check_xi_mssql_server!-U 'username' -P 'xxxxxx' -I 'MSSQLSERVER' -p 1433 --bufferhitratio --warning 90: --critical 95:

I then went to /usr/local/nagios/libexec and could not find the command check_xi_mssql_server. This command is missing. Is this a new feature?

the directory
is where your plugins exists, in your case check_mssql_server.py

-Yancy

Please advise how to correct the error I am having.

To summarize,
I have installed Nagios using your virtual image.
Windows and unix monitoring works well.
From a command line, I can run the check_mssql_server command and it responds quickly.
The wizard fails.

Please advise.

under views, service, service detail ( for the failing alert). I then selected reconfigure. In this box the command being issued is
check_xi_mssql_server!-U 'username' -P 'xxxxxx' -I 'MSSQLSERVER' -p 1433 --bufferhitratio --warning 90: --critical 95:

From the "Configure Service" screen, change the above line (remove the port), so that it look like this:
Click on "Update" -> Confinue -> Schedule an immediate check

and see if it is going to work this way.

I then went to /usr/local/nagios/libexec and could not find the command check_xi_mssql_server. This command is missing. Is this a new feature?

The "/usr/local/nagios/libexec" directory contains the plugins, not the commands. The commands are defined in "/usr/local/nagios/etc/commands.cfg". You will find the "check_xi_mssql_server" command defined there.

Can you direct me to where to change the configuration? From views, service, I selected configure and received the following

This service appears to make use of an advanced configuration. Use the Nagios Core Config Manager to modify the settings for this service.

Does the mssql wizard work? Do I need to manually configure all alerts by removing the -P option?

You will need to make this change from the CCM:

Configure > Core Configuration Manager > Services > Select the service that you need to change > Then here, change the arguments/etc the same way lmiltchev showed above. Once this is done, click save, then change the others and save them as well, then apply configuration.