20. Database Tier - Locks

Locks are used to grant explicit access when update of data is performed. Normally this is not an issue until there are too many sessions that are blocked by locks and they have been waiting for long time. This check will measure the number of blocked sessions and their max wait seconds.

Multiple Instances: No

Interval: Every 5 minutes (288 times per day)

Status	Expression
Critical	If ( Blocked Sessions > 15) and ( Max Wait Seconds > 1600 seconds)
Warning	If ( Blocked Sessions > 5) and ( Max Wait Seconds > 900 seconds)
OK	If not status Warning or Critical.
Unknown	Missing application response.