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

issue : ASE user connection

issue:

ASE user connection

Use cases:

 1. If it is ASE installation

 2. If App+DB are on same host or it is a Business Suite Installation.

how to verify:


"1. Switch to syb<SID> and check the log in the file below:
/sybase/<SID>/ASE16-0/install/<SID>.log

2. Error will be in below format:
Number of connections exceeded"


Solution:

"1. Switch to syb<SID>

2. login to isql:
isql -Usapsa -S<SID> -X
go

2. Change user connections:
sp_configure ""number of user connections"",375
go
"

ASE errorlog for any errors

hostname> less /syabase/syabse_ase/install/<SID>.log