MSSQL Transactions/Sec facing Null

[dimsum]

Hi Support,

I've a problem of mssql monitoring MSSQL Transactions/Sec facing Null error.

-U 'yyy' -P 'xxx' -T 'master' -p 1433 --transpsec --warning 10 --critical 20

How do i corrected value to monitor transpsec.

Thanks in advance.

[abrist]

Can you check it from the cli?

Code: Select all

./check_mssql_database.py -U 'yyy' -P 'xxx' -T 'master' -p 1433 --transpsec --warning 10 --critical 20

[dimsum]

Hi Abrist,

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

Please advice.

[abrist]

The script runs the query for transpec:

Code: Select all

execute("SELECT cntr_value FROM sysperfinfo WHERE counter_name='Transactions/sec' AND instance_name='" + table + "';")

Are you sure the table is correct?

[WernervanLooy]

There is a typo in the script. transpec instead of transpsec.

[tmcdonald]

There is a typo in the script. transpec instead of transpsec.

I don't think this is it. In the code they seem to have taken this common typo into account and "transpec" gives the same result as the correct "transpsec".

@dimsum: What version of the plugin are you running?

Code: Select all

grep -A20 "Changelog" /usr/local/nagios/libexec/check_mssql_database.py

Also what Nagios XI version is this on?