Lockwait parameter

Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
Locked
kotla
Posts: 1
Joined: Tue Aug 03, 2021 6:00 am

Lockwait parameter

Post by kotla »

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;;
Locked