Proactive Sybase DB space

Monitoring the total space occupied by sybase database only,doesn't answer below question.

• 1 year of DB growth is available for analysis. 
• Is data continuously growing and is it predictable that database runs out of space?

* The below practical steps only applicable for the Sybase Ase version 16 SP03 and above.

1. Login to ASE DB and execute the below command.

Hostname:/sybase/<sid> >dataserver - v

Result of the above command:

DB version. 

2. ASE Database system should be integrated in DBA Cockpit.

 

Practical steps:

1. Enter hostname in the DBA Cockpit search.

2. Click on the system search.

3.click on new database opened with system name

4.click on space tab

5.click on databases in the space drop-down.

6.select the database name(Sid).

7.click on show Growth option.

8.select time frame.

9.select Granularity

10.click on Apply selection.

11.Click on Chart tab.

12.Click on summary tab.

13.Click on Details tab.

14. Download report in Excel.

Supporting sap note: 2564157