Reviews (1-2 of 2)
December 08, 2019
Score 10 out of 10
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 availability and reliability.
- High performance.
- Monitoring of threshold based events.
- Security at multiple levels.
- Query plan optimization.
- Lock management.
- Access to HANA.
- Full database encryption - need to utilize external keys vs internal - for better separation of duties.
- History Tables.
Read Gene Baker's full review
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.
November 20, 2019
Score 10 out of 10
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.
- Easy to setup and maintain
- Reliable, rarely has major hiccups requiring reboots or crashes
- Very responsive with complicated queries spanning various tablespaces and hundreds of millions of rows
- A quick button for devs to switch instances into a dev mode (eliminating logs, and such).
- Licensing is far too complicated. Simplify pricing.
Read Zhann Goloborodko's full review
Great a business that needs a Database and doesn't want to invest in DBAs.
SAP ASE Scorecard Summary
About SAP ASE
SAP ASE Integrations
SAP ASE Competitors
Microsoft SQL Server, Oracle MySQL, IBM DB2
SAP ASE Technical Details