Nagios Support Forum

Hi,

MSSQL Server monitor works fine, but the DB monitor has multiple issues. I am testing on MSSQL 2008 R2 from Nagios XI 2012R2.3. I believe that I am running the latest version of the plugin:



Here is the result:


MSSQL Active Transactions
Unknown 8m 40s 5/5 2013-09-05 14:06:33 SQL Server message 208, severity 16, state 1, line 1:

MSSQL Connection Time
Ok 6m 58s 1/5 2013-09-05 14:09:15 OK: Time to connect was 0.00593996047974s

MSSQL Log Cache Hit Rate
Unknown 10m 19s 5/5 2013-09-05 14:09:54 SQL Server message 208, severity 16, state 1, line 1:

MSSQL Log File Usage
Unknown 8m 37s 5/5 2013-09-05 14:06:36 SQL Server message 208, severity 16, state 1, line 1:

MSSQL Log Flush Wait Time
Unknown 6m 54s 5/5 2013-09-05 14:08:19 SQL Server message 208, severity 16, state 1, line 1:

MSSQL Log Growths
Unknown 10m 15s 5/5 2013-09-05 14:09:58 SQL Server message 208, severity 16, state 1, line 1:

MSSQL Log Shrinks
Unknown 8m 33s 5/5 2013-09-05 14:06:40 SQL Server message 208, severity 16, state 1, line 1:

MSSQL Log Truncations
Unknown 6m 50s 5/5 2013-09-05 14:08:23 SQL Server message 208, severity 16, state 1, line 1:

MSSQL Transactions / Sec
Critical 10m 12s 5/5 2013-09-05 14:10:01 (null)

For the unknown status, it seems that Nagios is looking for the sys.sysperInfo table which has been depricated in 08 which uses sys.dm_os_performance _counters.

The MSSQL Transactions / Sec returns the following:


[root@nagios libexec]# ./check_mssql_database.py -H ********* -U 'sa' -P '**********' -T 'db_name' -p 1433 --transpsec --warning 10 --critical 20
Usage: check_mssql_database.py -H hostname -U user -P password -T table --mode

check_mssql_database.py: error: no such option: --transpsec

Any help much appreciated.

For the unknown status, it seems that Nagios is looking for the sys.sysperInfo table which has been depricated in 08 which uses sys.dm_os_performance _counters.

Thanks for the feedback! I was able to recreate the issue, and will let the developer know. I am not sure when a patch would be available, but you have to keep in mind that the plugin is used to monitor older servers as well, so "--transpec" should stay for the time being.

Any chance this might be resolved soon? I would really like to use this feature.

It has been a bit hectic this last month and we are all currently at the nagios conference, I might be able to talk to the developer tonight however I'd recommend adding a tracker item under "Bug" so we can update you there:

tracker.nagios.com

Just wondering if a fix might be anywhere in sight? Thanks.

jeffersjw,

This has been added to our internal bug tracker. Please let us know if you have any more details relevant.

NEW TASK ID 1342 created - Nagios XI Bug Report: MSSQL Database Monitor not working 2008R2