MSSQL Database Monitor not working 2008R2

[jeffersjw]

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.

[lmiltchev]

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.

[jeffersjw]

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

[slansing]

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

[jeffersjw]

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

[yancy]

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