Detailed information for the notes.ini Keyword: 

Collect_DB_Lock_Waits


Short Description: If enabled will display LockWaits and AvgWait values in the Show DBS console command.

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.

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:

Because this setting consumes server resources, remove it after you view Show DBS statistics.





Default value:
None

Syntax:
Collect_DB_Lock_Waits=0 / 1

Example:
Collect_DB_Lock_Waits=1

UI equivalent:
There is no kown UI setting for this notes.ini variable. But you can specify this setting in the notes.ini settings tab of the configuration settings document.


Applies to:
Server