Message

"Latch waits for latch latchname are n. The current threshold is threshold."

Description

Sent when the number of latch counts is above the threshold.

Type

Polled

Action

Review which users are accessing and using the latches. Review the -spin setting for the database.

Note

These details reflect a per-latch basis. There are 31 latches for a database. There can be more than one latch for this rule, and each latch should be a separate rule that must be evaluated.