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.
Host	Refers to the IP address of the Sybase ASE server.
Port	The port number at which the Sybase server listens to.
User	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”.
Password	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.	MB
Reserved space percent	The percentage of space reserved for tables and indexes of a database.	Percent	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.	MB	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.	MB
Index space	The amount of space used by indexes.	MB
Unused space	The amount of free space available in the database.	MB