The Database Information screen displays the current activity on the server.
The current number of an item in use.
The maximum number of resources actually in use at one time since the Advantage Database Server was loaded/started.
Shows the initial number of an item that the Advantage Database Server has available.
Indicates that a configured value has been exceeded and the Advantage Database Server was unable to allocate more resources for additional items. If numbers frequently appear in this column, it is an indication that the configuration parameters should be increased or a larger user option should be purchased.
A user is defined as a single client workstation connected to the Advantage Database Server. The number of users is not configurable. The Advantage Database Server option purchased determines the maximum number of users.
With Advantage DOS client applications, a connection is an individual application that can access the Advantage Database Server.
With Advantage Windows client applications, a connection is defined as an individual 16-bit application, an individual thread in a 32-bit application, or it can be obtained by a call to the specific Advantage Windows Client API to obtain a new connection. Each user can have multiple active connections.
A work area is a logical "container" that consists of a single open table, an optional memo file, and up to 15 index files.
A table in your database.
An index file in your database.
A data lock is an individual record lock, table lock, index file lock, memo file lock, or table header lock.
Advantage Database Server Worker Threads perform the actual database operations on the server.