SAP Adaptive Server Enterprise (ASE)

We use SAP ASE to run in-house built-in applications related to cybersecurity. We use it to monitor the DBMS-related vulnerabilities. We store, process, and manage a large amount of product-related data and query statements, alert management, and security threat mechanisms. This helps us to efficiently handle a large number of SQL statements and generate alerts in case of any security vulnerability by generating alerts to the DBA and other users for the DB.

We use this for an inbuilt security management system, where it performs well in a scaled setup with a large volume of live data with high availability. Also, the performance is up to the mark for the large statement flow. From a DBA perspective, a lot of parameters need to be fine-tuned for the specific environment needs, which can cause overhead. Expertise is limited, and the learning curve is steep for the SAP ASE.

We use ASE as the foundation for our 401(k) record keeping system. We store approximately 35,000 data elements spread across 24 databases and 2,000 tables. We have approximately 40 TB of data stored in our database. SAP ASE allows us to serve our many clients and business partners concurrently given its high performance and high availability features. Our application is an enterprise application used to service a number of clients both internal and external. SAP ASE is not an enterprise solution within our organization but is used by our department and several others departments for various financial applications. Our application started in 1992 and was originally sold as a licensed product and through merger and acquisition became owned by the bank.

High-performance, high-concurrency transactions are well suited for ASE. ASE is lacking some features in my opinion such as history tables, however there are ways to implement them via workarounds or by using Replication Server. I do think the way the ASE parser and optimizer works are far superior to other products as it is a true cost-based optimizer and the order of the tables in the FROM clause does not really matter although a good SQL coder will place the tables in a meaningful order to make the SQL more readable. ASE is good for applications that require high availability and can be used for mission critical systems.

We use ASE as our primary DB. It handles data across virtually all departments. We have hundreds of billions of rows of data spanning many decades. Given the amount of work it does within our organization, it is incredibly reliable rivaled by SQL Server in stability and performance. Given that our organization doesn't employ DBAs and that all our DBs are developers, Sybase has made our lives relatively easy considering what we ask of it.

Great a business that needs a Database and doesn't want to invest in DBAs.