Page 1 of 1
MSSQL Transactions/Sec facing Null
Posted: Fri Oct 25, 2013 5:30 am
by 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.
Re: MSSQL Transactions/Sec facing Null
Posted: Fri Oct 25, 2013 1:29 pm
by 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
Re: MSSQL Transactions/Sec facing Null
Posted: Sat Oct 26, 2013 1:33 am
by dimsum
Hi Abrist,
Result.
check_mssql_database.py: error: no such option: --transpsec
Please advice.
Re: MSSQL Transactions/Sec facing Null
Posted: Mon Oct 28, 2013 11:02 am
by 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?
Re: MSSQL Transactions/Sec facing Null
Posted: Thu May 08, 2014 3:48 am
by WernervanLooy
There is a typo in the script. transpec instead of transpsec.
Re: MSSQL Transactions/Sec facing Null
Posted: Thu May 08, 2014 11:47 am
by tmcdonald
WernervanLooy wrote: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?