SQL/MP Installation and Management Guide

Measuring Performance
HP NonStop SQL/MP Installation and Management Guide—523353-004
13-11
SQL/MP Measurement Models
•
LOCK-WAITS stores the number of times a call to the disk process waited on
locked data.
•
TIMEOUTS stores the number of timeouts issued on the file. If the number is
greater than zero, the file’s timeout value might be too low, thereby defining an
insufficient time.
•
ESCALATIONS stores the number of times a record lock was escalated to a file
(table) lock.