Try our new research platform with insights from 80,000+ expert users
PeerSpot user
Senior Sybase DBA at a tech services company with 1,001-5,000 employees
Consultant
Its simplicity of use has a high value, but it needs better marketing.

What is most valuable?

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.

How has it helped my organization?

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.

What needs improvement?

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.

For how long have I used the solution?

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.

Buyer's Guide
SAP Adaptive Server Enterprise
October 2024
Learn what your peers think about SAP Adaptive Server Enterprise. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
815,854 professionals have used our research since 2012.

What was my experience with deployment of the solution?

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.

What do I think about the stability of the solution?

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.

What do I think about the scalability of the solution?

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.

How are customer service and support?

Customer Service:

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

Technical Support:

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

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

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.

How was the initial setup?

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.

What was our ROI?

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.

What other advice do I have?

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.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Project and IT Architecture Manager at a security firm with 1,001-5,000 employees
Real User
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.
PeerSpot user
Buyer's Guide
SAP Adaptive Server Enterprise
October 2024
Learn what your peers think about SAP Adaptive Server Enterprise. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
815,854 professionals have used our research since 2012.
Fredy Alfaro - PeerSpot reviewer
Systems Engineer at a tech services company with 1-10 employees
Real User
Top 5
A good transactional database that needs to keep documentation open to distributors
Pros and Cons
  • "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."

What is most valuable?

SAP Adaptive Server Enterprise is a good transactional database. 

What needs improvement?

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

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

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

What other advice do I have?

I rate the solution a nine out of ten. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user725928 - PeerSpot reviewer
Programmer and Analyst with 1,001-5,000 employees
Vendor
An easy to learn and use solution for storing data

What is most valuable?

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

How has it helped my organization?

Cheaper, sufficient solution to store data, 400GB.

What needs improvement?

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

For how long have I used the solution?

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

What was my experience with deployment of the solution?

No.

What do I think about the stability of the solution?

After version 12.0, there have been no issues.

What do I think about the scalability of the solution?

No, but I am a developer.

How are customer service and technical support?

Customer Service:

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

Technical Support:

It is okay.

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

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

How was the initial setup?

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

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

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

Which other solutions did I evaluate?

Decision was made by the project leaders.

What other advice do I have?

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.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Download our free SAP Adaptive Server Enterprise Report and get advice and tips from experienced pros sharing their opinions.
Updated: October 2024
Product Categories
Relational Databases Tools
Buyer's Guide
Download our free SAP Adaptive Server Enterprise Report and get advice and tips from experienced pros sharing their opinions.