SAP Adaptive Server Enterprise Review

During the last 20 years, I have never had a stability problem with this product. Small specific bugs, but not affecting 24/7 operations


What is most valuable?

  • OLTP features
  • Robustness
  • Reliability

How has it helped my organization?

We receive millions of events from our customers and ASE. We are able to process them with thousand of operators working concurrently 24/7.

Usual activity is 1900 user & application connections, 1,500 transactions/sec, and 38,000 queries/sec

What needs improvement?

Cluster features: The Cluster Edition didn't get the same level of reliability as the Enterprise Edition did.

For how long have I used the solution?

I have been using it for the last 20 years.

What do I think about the stability of the solution?

During the last 20 years, I have never had a stability problem with this product. Small specific bugs, but not affecting 24/7 operations.

What do I think about the scalability of the solution?

Old versions had problems with scalability, due to blocking issues with high concurrence. After version 15, this was improved.

How are customer service and technical support?

I have had no problems with tech support. Most of the issues were related to licensing problems. For bugs, we got quick fixes or workarounds.

Which solution did I use previously and why did I switch?

We used MS SQL. We switched to ASE due to the scalability of the solution. We still use MS SQL in other small solutions.

How was the initial setup?

Compared to other database engines, I think it's one of the easier ones, in terms of initial setup.

What's my experience with pricing, setup cost, and licensing?

If you have more than one SAP product, it's good to take advantage of the platform licenses because you can move them from one product to another on demand.

Which other solutions did I evaluate?

Yes, Oracle Database with RAC. We considered it more complex to setup, maintain, and it's more expensive.

What other advice do I have?

Check the new Hana evolution. They are building a new solution that isolates applications to the database layer. It has very interesting features. We are in the process of evaluating it.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
1 visitor found this review helpful
Add a Comment
Guest
Sign Up with Email