Detailed information for the notes.ini Keyword: 


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

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.


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

Default value:

Collect_DB_Lock_Waits=0 / 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: