SAP Adaptive Server Enterprise Reviews

It is difficult to say which features are most valuable for me. I believe that any set of features are valuable and that depends on specific intent and situations, but only simplicity of use has a high value in any case.

ASE is designed primarily for use on high-end servers and, according to Sybase, is especially good at handling online transaction processing (OLTP) workloads. Unfortunately, I cannot share any further information regarding how my organization uses the product.

In my view, this product is underrated and needs more aggressive/active advertising in the business world. I believe that SAP started it on the right way when they optimized SAP ASE 16 for SAP Business Suite applications, because this can help businesses to improve operational efficiency and significantly reduce overall costs.

The first time I was faced with RDBMS Sybase ASE was in 2005; before that, I worked with Oracle databases. My acquaintance with Sybase ASE was very unique. I worked for a financial institution on a developer position, where my task at that time was to create software that allowed people without strong IT skills to migrate from v12 to v15 in around 160 branches. For this reason, I started to learn the Sybase database and DBA routines before really starting my main task. Since 2005, I have worked very closely with Sybase ASE 12.0 & 12.5 as a developer and later, after migration to version 15.X, as a database administrator. At the same time, I was acting as chief of the relevant department.

I have not had any very serious issues (mostly on Windows platform), but if all the required pre-installation/deployment steps are performed with accuracy, then the DBA/System Administrator probably will not encounter any issues during installation/deployment.

Yes, but only one time. The issue was related with a Java applet that was run on the same server as the database. An error in the applet-code caused, from time to time, another instance of the to applet run. A gradual rise in memory that the applets used led to us running out of memory that the database server demands.

I did not encounter any issues with scalability. The system allows you to easily scale the amount of users, data and transactions for very large database environments.

It's not bad; I can’t say that there has been anything significant.

I would rate the level of technical support as mostly very good. Whenever I needed help/advice from support, I received it on time.

In most cases businesses choose software products that they need for daily business activity; unfortunately, a database in most cases is not an option. Within my recollection, there was only one time in the company that I worked for in the past that changed business software as well as the database related to it.

In my view, the official initial setup guide is very well-documented and anyone can find this information on 'The SyBooks Online' infocenter (definitive source for Sybase documentation on the internet). As a result, the initial setup is very straightforward in most cases. However, some difficulty can be experienced with the SAP ASE servers that are configured with a failover in a high availability system, but most companies don't use this very often.

I believe that Sybase ASE, can help enterprises advance through operational efficiencies and significantly increase ROI in today’s operational climate of big data, voluminous users and massive online transactions, when businesses need a leading-edge database system to keep them moving full speed ahead on path possible irregularities.

This product has my complete confidence. ASE is very reliable and an easy-to-maintain product, with far reaching functionality and a cost which is less than other similar products. I believe that in the foreseeable future I could rate this product 10/10, but now it should be a little bit less.

My advice concerning not only this product, but any product, is to be honest and don't be prejudiced into making a decision about a product because of the vendor's reputation. Businesses should make the choice not based on general tendency, but on real needs. I believe you already follow it if you chose SAP ASE.

• OLTP features
• Robustness
• Reliability

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

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

I have been using it for the last 20 years.

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

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

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.

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

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

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.

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

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.

SAP Adaptive Server Enterprise is a good transactional database. 

The solution should improve view partitioning. The documentation is very confined and available only for users. Distributors also would like access to it. 

I rate SAP Adaptive Server Enterprise's pricing a six out of ten. 

I rate the solution a nine out of ten. 

• Price
• Stability
• Easy to use
• Easy to learn
• Powerful SQL
• Transact-SQL
• Query optimizer

Cheaper, sufficient solution to store data, 400GB.

Better promotion. Sybase seems little known. I noticed it on DB websites.

18 years, with the last four years using it at intervals (app changes and administration).

No.

After version 12.0, there have been no issues.

No, but I am a developer.

It is sufficient for me. As for our customers, it is okay.

It is okay.

I used DB2 on AS400. It was great. I switched due to an employer switch.

Installation and setup is straightforward above version 12.x. Learn usage, too.

Developers would not dealing with licenses when doing install and using it. Simply install and use.

Decision was made by the project leaders.

Sufficient, robust, power DB. Oracle is more powerful, complex, and expensive, with a different philosophy on batch and SQL and has broader usage of functions.