Nagios Support Forum

Hi Vinh, all you said was perfeclty clear to me in the first place. As our "DB Admin" is not a real, skilled db admin, I don't have anyone to ask. that's why I wrote my post here. Someone from Nagios should understand the meaning of that indicators and could point me in the right direction...

/usr/local/nagios/libexec/check_mssql_server.php -H 10.10.250.203 --checktype 'server' -U 'nagiosxi' -P 'Monitor_2020' --perftype default -p 1433 --mode totalpages --warning 900000 --critical 1000000 CRITICAL: Total pages is 1048576.0|totalpages=1048576.0;900000;1000000;; 900.000 for the warning ale...

Hi Vinh,
I'm not a real DBA myself... I know how to set warning and critical values, but I need the correct values to set... the wizard suggested some but my systems are breaching a lot of them.

bye, Dario

Hi Vinh and thank you for you reply. I already checked that document, but it clearly states: "Each of the wizards has different metrics that can be measured. The metrics available are clearly explained in the wizards and hence will not be covered here". Well, that debatable, as the metrics...

We need help setting up a correct MSSQL monitoring with Nagios XI.

Is there any specific documentation that explains how to set up the best warning and critical values for a specific MSSQL server?

I know, it's probably a noob question... still we need some help here.

bye, Dario

Same issue here, we were trying to configure the Google Map component but after 5.8 upgrade it displays the "Component function does not exist.". To be precise, every other configurable component is giving the same error.

bye, Dario

Nice, thanks.

bye, Dario

5.7.1 seems to be faster...

bye, Dario

Hi, sorry for the delay. There was a mismatch between the version I set up in the wizard and the real sql version on the server. My bad, sorry!

bye, Dario

We're having some issues monitoring SQL.

After running the wizard, a lot of the SQL checks randomly report this error:

<type 'exceptions.DivisionByZeroError'>

Then after a while it disappear (or more ofter show up on another check, as not all the checks fail at the same time!).

Bye, Dario