Sybase Database Space Usage Test

This test reports the space usage of all Sybase databases.

Target of the test : A Sybase ASE (Below v15) server

Agent deploying the test : An internal agent

Outputs of the test : One set of results for every Sybase ASE (Below v15) 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 server.
Port	The port number at which the Sybase server listens to.
User	A Sybase user who has the “sa_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.

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