Sybase Database Space Usage Test

This test reports the space usage of all Sybase databases, and sheds light on those databases that are running short of space.

Target of the test : A Sybase ASE server on which the MDA tables have been installed

Agent deploying the test : An internal agent

Outputs of the test : One set of results for every Sybase ASE server being monitored.

Configurable parameters for the test
Parameter Description

Test Period

How often should the test be executed.


Refers to the IP address of the Sybase ASE server.


The port number at which the Sybase server listens to.


To enable this test to connect to the Sybase server and collect the required metrics, it is enough if you configure the test with the name of a Sybase user who has the “mon_role”. However, for best results, it is recommended that you configure all Sybase tests with the credentials of a Sybase user who has the “mon_role”, “sa_role’, and “sybase_ts_role”.


The password corresponding to the above user.

Confirm Password

Confirm the password by retyping it here.

Include DB

Specify a comma-separated list of databases that you wish to monitor in the Include DB text box. By default, this is set to all.

Exclude DB

Specify a comma-separated list of databases that you wish to exclude from the scope of monitoring in the Exclude DB text box. By default, this is set to none.

Use Stored Procedure

By default, this flag is set to Yes, indicating that the test uses a stored procedure for collecting space usage metrics. To use this stored procedure, the eG agent requires sa_role privileges. In high security environments, where administrators may not prefer to expose the credential of a user with sa_role privilegs to the eG agent, you can configure the eG agent to run a query instead for pulling the required metrics. To enable the eG agent to use this query, set the Use Stored Procedure flag to No.

Measurements made by the test
Measurement Description Measurement Unit Interpretation

Total size

The space allocated to a database.



Reserved space percent

The percentage of space reserved for tables and indexes of a database.


If the value of this measure reaches 100%, it indicates that the total space in the database has been completely allocated. New tables/indexes can be added to the database, only if its total size is increased.

Reserved space

The amount of space allocated to the tables and indexes created on a database.


If the value of this measure becomes equal to that of the Total size measure, new tables/indexes can no longer be created on the database. To create new tables, you must increase the database size.

Data space

The amount of space used by data.



Index space

The amount of space used by indexes.



Unused space

The amount of free space available in the database.