sp_mgGetActivityInfo

Advantage SQL Engine

This procedure returns information about the current activity on the Advantage Database Server.

Syntax

EXECUTE PROCEDURE sp_mgGetActivityInfo()

Parameters

Operations (O)

Total number of operations performed since the server started.

LoggedErrors (O)

Number of errors logged since server started.

UpTime (O)

Total time the Advantage Database Server has been in operation in Days, Hours, Minutes and Seconds.

Remarks

sp_mgGetActivityInfo returns three parameters of the ADS_MGMT_ACTIVITY_INFO structure returned by AdsMgGetActivityInfo. The additional items not returned from the ADS_MGMT_ACTIVITY_INFO can be retrieved using sp_mgGetUsageInfo.

Note With the Advantage Local Server, sp_mgMgGetActivityInfo will only return information for the instance of Advantage Local Server currently loaded into memory.

Example

EXECUTE PROCEDURE sp_mgGetActivityInfo();

See Also

sp_mgGetUsageInfo