Below in few short steps You find information how to check and resize Sybase database. I hope it will be helpful for You.Read More
Sometimes in Your Sybase environment You can see error like “ASE has run out of LOCKS. Re-run your command when there are fewer active users, or contact a user with System Administrator (SA) role to reconfigure SQL Server with more LOCKS.” This error occurs when Adaptive Server runs out of locks…Read More
From Version 16.0 SP03 of SAP Adaptive Server Enterprise (ASE), the database has the option of integrated monitoring. The new functionality is called Built-In ASE Longterm Monitoring Data Repository (BALDR). This replaces the data collection framework (DCF) injected by the DBA cockpit when monitored by an SAP DBA Cockpit or Solution Manager System. Sometimes in SM21 You can find below ASE Error SQL156:Read More
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