Lockwait parameter

Engage with the community of users including those using the open source solutions.
Includes Nagios Core, Plugins, and NCPA

Lockwait parameter

Postby kotla » Tue Aug 03, 2021 6:08 am

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;;
kotla
 
Posts: 1
Joined: Tue Aug 03, 2021 6:00 am

Return to Community Support

Who is online

Users browsing this forum: No registered users and 12 guests