sp_mgGetConfigMemory

Advantage SQL Engine

Returns Advantage Database Server configuration information that affects the amount of memory required by the Advantage Database Server

Syntax

EXECUTE PROCEDURE sp_mgGetConfigMemory()

Parameters

Item (O)

Name of the item.

Value (O)

Value from the server.

Memory (O)

Amount of memory used in bytes.

Remarks

This procedure returns the following items:

Connections

Work Areas

Tables

Indexes

Locks

User Buffer Size

TPS Header Elems

TPS Visibility Elems

TPS Memo Elems

Receive ECBs

Send ECBs

Worker Threads

Total Memory

Example

EXECUTE PROCEDURE sp_mgGetConfigMemory();

See Also

sp_mgGetConfigInfo