The Locks window shows information about the locks.

Lock wait ratio

Percentage of locks which are waiting. Any time a connection waits for another connection to complete its transaction, the overall response time for an application is affected.

Locks per second

Byte byte lock
IS Intent shared lock
S Shared lock
SR Shared lock held by repeatable reader
U Update lock
UR Update lock held by repeatable reader
IX Intent exclusive lock
SIX Shared intent exclusive lock
X Exclusive lock
XR Exclusive key value held by repeatable reader

Lock requests per second

Number of lock requests per second

Deadlocks per seconds

Number of deadlocks per second. (deadlock: a candidate is chosen and terminated to resolve a deadlock)

Attemps to exceed the max number of locks /s

Is the number of times that the database server attempted to exceed the max number of locks (LOCKS in onconfig).

See also:

Go back to the Learning center:

Copyright © AgileLoad. All rights reserved.
Agile Load testing tool| Contact AgileLoad | Terms of Use | Sitemap