In last time I observed in my Sybase database situations like this:
- The dataserver process of the SAP ASE server leaks memory – total size of memory allocated to the dataserver process is constantly growing.
- SAP ASE server is inaccessible and silently crashes.
- In logs I found many entries like in below frame.
In transaction ST22 You probably can find information similar to below:
Database error text: “SQL message: [ASE Error SQL712][SAP][ASE ODBC Driver][Adaptive Server Enterprise]There is insufficient heap memory to allocate 36432 bytes. Please increase configuration parameter ‘heap memory per user’ or try again when there is less activity on the syst”Read More