Advantage SQL Engine
Returns information about the current activity on the Advantage Database Server.
EXECUTE PROCEDURE sp_mgGetUsageInfo()
Item (O) |
Name of the activity. |
InUse (O) |
Number of items in use. |
MaxUsed (O) |
Maximum number of items ever used. |
Configured (O) |
Number configured on the server. |
Rejected (O) |
Number of items rejected. |
This procedure returns the following items:
Users
Connections
Work Areas
Tables
Indexes
Locks
TPS Header Elems
TPS Visibility Elems
TPS Memo Elems
Worker Threads
To get the server up-time, errors logged, or number of operations use the sp_mgGetActivityInfo procedure.
Note With the Advantage Local Server, sp_mgGetUsageInfo will only return information for the instance of Advantage Local Server currently loaded into memory.
EXECUTE PROCEDURE sp_mgGetusageInfo();
See Also