Nagios Support Forum

Hi ALL

we have tested lockwaits using below command and we are getting the delta time each time we generate the alert for only one session. Not sure how do we get the alerts without the delta time

./check_mssql_server.php -H 172.19.155.61 --checktype 'server' -U 'xxxxxxxxxx' -P 'xxxxxxxxxx' --perftype default -p 1433 --mode lockwait --warning 30 --critical 60
OK: Lock Wait Time (ms) is 3.484ms|lockwait=3.484ms;30;60;;
[root@xhd-dvapngo01 libexec]# ./check_mssql_server.php -H 172.19.155.61 --checktype 'server' -U 'xxxxxxxxxx' -P 'xxxxxxxxxx' --perftype default -p 1433 --mode lockwait --warning 30 --critical 60
OK: Lock Wait Time (ms) is 0.000ms|lockwait=0.000ms;30;60;;
[root@xhd-dvapngo01 libexec]# ./check_mssql_server.php -H 172.19.155.61 --checktype 'server' -U 'xxxxxxxxxx' -P 'xxxxxxxxxx' --perftype default -p 1433 --mode lockwait --warning 30 --critical 60
CRITICAL: Lock Wait Time (ms) is 1912.9ms|lockwait=1912.9ms;30;60;;
You have mail in /var/spool/mail/root
[root@xhd-dvapngo01 libexec]# ./check_mssql_server.php -H 172.19.155.61 --checktype 'server' -U 'xxxxxxxxxx' -P 'xxxxxxxxxx' --perftype default -p 1433 --mode lockwait --warning 30 --critical 60
OK: Lock Wait Time (ms) is 0.000ms|lockwait=0.000ms;30;60;;
[root@xhd-dvapngo01 libexec]# ./check_mssql_server.php -H 172.19.155.61 --checktype 'server' -U 'xxxxxxxxxx' -P 'xxxxxxxxxx' --perftype default -p 1433 --mode lockwait --warning 30 --critical 60
OK: Lock Wait Time (ms) is 0.6667ms|lockwait=0.6667ms;30;60;;