sp_mgGetUsageInfo

Advantage SQL Engine

Returns information about the current activity on the Advantage Database Server.

Syntax

EXECUTE PROCEDURE sp_mgGetUsageInfo()

Parameters

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.

Remarks

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.

Example

EXECUTE PROCEDURE sp_mgGetusageInfo();

See Also