Notes.ini Entry - Collect_DB_Lock

Notes.ini Entry

Name:	Collect_DB_Lock_Waits
Syntax	Collect_DB_Lock_Waits=0 / 1
Applies to:	Servers
Add-on:
First Release:
Obsolete since:
Category:	Statistics, Performance
Default:	None
UI equivalent:	None

Description:
To display LockWaits and AvgWait values in the Show DBS console command, you must temporarily add the setting COLLECT_DB_LOCK_WAITS=1 to the server's NOTES.INI file. Because this setting consumes server resources, remove it after you view Show DBS statistics.

Show DBS command

The Show DBS command is a tool for monitoring the performance of a database. This command returns the following information:

Refs -- The number of times the database has been opened (the DBHANDLE count for the database).
Mod -- Whether the database has been modified, but not yet flushed to disk.
FDs -- The number of file descriptors currently being used for the database.
LockWaits -- The number of times a user has had to wait for a lock on the database (read or write).
AvgWait -- The average wait time in milliseconds for each wait.
#Waiters -- The number of waiters currently on the database lock. (This number changes rapidly.)
MaxWaiters -- The maximum number of waiters ever on the database lock.

Note To display LockWaits and AvgWait values, you must temporarily add the setting COLLECT_DB_LOCK_WAITS=1 to the server's NOTES.INI file. Because this setting consumes server resources, remove it after you view Show DBS statistics.