No more typing reviews! Try our Samantha, our new voice AI agent.

SAP Adaptive Server Enterprise vs SQL Server comparison

Why PeerSpot?
 

Comparison Buyer's Guide

Executive SummaryUpdated on Mar 4, 2025

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

SAP Adaptive Server Enterprise
Ranking in Relational Databases Tools
20th
Average Rating
8.4
Reviews Sentiment
5.9
Number of Reviews
14
Ranking in other categories
No ranking in other categories
SQL Server
Ranking in Relational Databases Tools
1st
Average Rating
8.4
Reviews Sentiment
6.4
Number of Reviews
277
Ranking in other categories
Database Management Systems (DBMS) (2nd)
 

Mindshare comparison

As of November 2026, in the Relational Databases Tools category, the mindshare of SAP Adaptive Server Enterprise is 1.6%, up from 1.0% compared to the previous year. The mindshare of SQL Server is 10.2%, down from 14.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Relational Databases Tools Mindshare Distribution
ProductMindshare (%)
SQL Server10.2%
SAP Adaptive Server Enterprise1.6%
Other88.2%
Relational Databases Tools
 

Featured Reviews

reviewer2784705 - PeerSpot reviewer
Senior Advisor at a government with 10,001+ employees
Long term database experience has supported OLTP workloads and delivers reliable cross platform migrations
SAP is not putting money into modernizing SAP Adaptive Server Enterprise. One of the things I discovered on the last project I was on was that they did not incorporate the Intel new instruction set in SAP Adaptive Server Enterprise. Intel has augmented its instruction set referred to as new instructions. They did that to make conversion easier. When you migrate SAP Adaptive Server Enterprise cross-platform, you go through a process where it converts the character set. If you are going from AIX to Linux or from Solaris to Linux, Linux is referred to as Little Endian, while AIX or Solaris are considered Big Endian. This is determined by how the product stores data. The word size of these processors is 32 bits long. If you start numbering from the little end, it is referred to as Little Endian. If you start numbering from the big end, it is called Big Endian. To migrate a SAP Adaptive Server Enterprise database from a Big Endian setup like AIX or Solaris to migrate to a Big Endian setup on an Intel, the operating system determines whether it is Little Endian or Big Endian. When you migrate from Big Endian to Little Endian, the database has to go through a character set conversion, and some of these databases are quite large with gigabytes and gigabytes of data. They have to do a character set conversion to the existing database before they do anything else. The worst part is that you have to rebuild all the indexes when you do that. When you switch endianness of the database, you have to rebuild all the indexes. It will automatically do that for system tables, but for actual user databases, you have to rebuild all your indexes, and it takes a long time. SAP Adaptive Server Enterprise is a relational database and is the predecessor of Microsoft SQL Server. All that functionality that Microsoft SQL Server had came from essentially SAP Adaptive Server Enterprise. The problem with SAP Adaptive Server Enterprise these days is it is not expanding its place in the marketplace or expanding its position in the marketplace. A lot of companies have migrated away from SAP Adaptive Server Enterprise. It works fairly well, but the problem is SAP Adaptive Server Enterprise was architected to be an OLTP engine and is now doing things for larger databases that were not in its original intended purpose. The endianness of the RDBMS is a major impediment to continuing to use SAP Adaptive Server Enterprise. You have a multi-gigabyte database, and it will go through a conversion process in a single-threaded fashion, and then you have to rebuild the indexes. Rebuilding the indexes is lengthy and time-consuming. The part of the conversion process that is concerned with conversion of the character set is single-threaded. You may have eight cores on your machine or virtual machine and only one can be used in the conversion process. There is another problem with the whole thing in that it will sometimes not operate properly. Under certain workloads, SAP Adaptive Server Enterprise will become overwhelmed. When you convert it, it does not operate properly in all circumstances. The root cause of that is that SAP in its desire to save money and desire to orphan the product has not recompiled or redeveloped the product to take advantage of the Intel new instruction set. Other relational databases such as Oracle and Microsoft SQL Server have the same issue to deal with, but with those platforms, they are taking advantage of the new instruction set. There are some additional Intel instruction sets or instructions in their Intel instruction set. With SAP Adaptive Server Enterprise, they did not bother to incorporate support for the new instruction set instructions. In certain circumstances, the database does not operate properly. It is unable to do what it needs to do. If you do your research and go on the internet and see what happens with Oracle or Microsoft SQL Server, what comes back is that it takes 4% longer to perform a lot of the instructions. When you are using the new instruction set, it adds 4% to the runtime of the database.
Shakti Gupta - PeerSpot reviewer
SQL server database administrator at a tech vendor with 10,001+ employees
Hybrid data platform has strengthened performance, security, and incident response for production
SQL Server is very mature, but I see areas for improvement, especially in performance tuning, troubleshooting, and automation. Although tools such as Query Store and dynamic management views are powerful, some troubleshooting tasks still require senior SQL Server database administrator expertise. It would be valuable to have more intelligent, built-in recommendations for root cause analysis, indexing, blocking, and query optimization. I would also like to see simplified and consistent management across on-premises SQL Server and Azure SQL services, as managing hybrid environments sometimes requires different tools and approaches. Finally, improved patching, updates, monitoring, and cost and license transparency could make SQL Server easier to manage at the enterprise scale. One area I would improve in SQL Server is its documentation and troubleshooting guidance. SQL Server documentation is comprehensive, but for complex production issues, I would like to see more real-world troubleshooting examples, especially for scenarios such as Always On synchronization issues, blocking and deadlocks, performance degradation, and upgrade features.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"Sufficient, robust, power DB."
"I like that SAP ASE can match code and the database index to index data in the programming language."
"They provide easy integration with other systems."
"Provides very good integration."
"This is a wonderful database that is, in my opinion, underrated. Users are able to get the most out of my experience by taking advantage of its centralized environment."
"I like that SAP ASE can match code and the database index to index data in the programming language. There are many other valuable features, such as the table buffer, tuning, and various control agents like dispatcher. SAP ASE can handle many different data types, including views, domains, data elements, structures, objects, and various table types that are most useful in the application. Its modularization technique is also handy."
"In SAP Adaptive Server Enterprise, there are some built-in stored procedures that you can use to fire those commands and get the data in a very systematic manner where you can see the results."
"SAP ERP offers us a robust platform where financial stakeholders spend less time collating and sourcing out records and implementing payments."
"There was an online system in which we had about 2500 requests to the DB per second. Every request had a completion window of one second to process and retrieve data. After switching to SQL Server, and AlwaysOn, and Snapshot, and tinkering, and configuring and tinkering, the handling capacity we measured increased to about 5000 requests per second, while the time decreased to 0.5 seconds per request."
"Technical support has been helpful and responsive."
"I have found that SQL Server works very well in the Microsoft Dynamics environment."
"SQL Server is definitely easy to use, and with the volume that we have, it's also stable."
"It is stable, and it works okay."
"SQL is very easy to manage."
"The most valuable feature is easy installation. It was very easy to install."
"The backup capabilities are extremely good."
 

Cons

"The solution should improve view partitioning. The documentation is very confined and available only for users. Distributors also would like access to it."
"Cost-wise, SAP is still expensive compared to other available products."
"In my opinion, product support is not that great from SAP because they have already declared the end-of-date for SAP ASE. They will be stopping product support."
"Because the solution is customized. we do occasionally face unique bugs. There are always some changes that need to be made here and there."
"There could be some improvements in barcode scanning and RFID access."
"Cluster features: The Cluster Edition didn't get the same level of reliability as the Enterprise Edition did."
"The solution is kind-of expensive."
"I'd like to see a more friendly user interface."
"The solution has legacy issues when it comes to compatibility."
"The solution’s initial setup could be complex, requiring some design of how you want to lay everything out and what type of storage you want to put certain things on."
"Maintenance of the solution is an area of concern, and improvements can be helpful."
"There was a time when Microsoft support provided very crisp answers, but over time, they have diluted their support to third parties, leading to a drop in support quality, which restricts me from giving a perfect 10, as post-sales service is crucial."
"It will be very useful to have high-level database monitoring. It should also have built-in business intelligence reporting."
"The only item which I can list is application failure during Integration Services debugging, when restarting a process flow. In a number of instances the solutions fails. I have not given this much thought and simply stop and start the debugging service rather than restarting."
"The free version is cumbersome to use and maintain. But $5000 for a licence is more expense than the benefit I would get from a licensed version."
"Most of the large banks are shifting from SQL Server to Oracle Database because of its slowness."
 

Pricing and Cost Advice

"Price-wise, the product is worth it since one needs very less infrastructure to use it."
"The licensing cost for ASE is pretty low."
"I rate SAP Adaptive Server Enterprise's pricing a six out of ten."
"Licensing fees are paid on a yearly basis."
"Depending upon your usage, you can use the pay-as-you-go model for a short period of time. For longer projects, we can opt for one-year or a three-year license."
"The price of the solution is very expensive. If I went with the cloud version of SQL a license would cost me approximately 11,000 Riyals per month."
"There is a license required for this solution. One of the problems is for smaller businesses to purchases a license because it is expensive for a lot of them to afford."
"I believe the licensing to be on an annual basis."
"On a scale of one to ten, when one is cheap and ten is an expensive solution, I rate the product price as seven. The product is expensive."
"The price of SQL Server could be better in the African market. The licensing model needs to be improved, it is confusing."
"We have an enterprise license, which we consider to be fine."
report
Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
922,349 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Construction Company
15%
Financial Services Firm
12%
Outsourcing Company
9%
Manufacturing Company
8%
Financial Services Firm
34%
Outsourcing Company
10%
Manufacturing Company
7%
Construction Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business3
Large Enterprise11
By reviewers
Company SizeCount
Small Business119
Midsize Enterprise61
Large Enterprise123
 

Questions from the Community

What is your experience regarding pricing and costs for SAP Adaptive Server Enterprise?
From a pricing perspective, I would say the solution is fairly priced. In Oracle, you have two or three databases at most on one machine. In SAP Adaptive Server Enterprise, one machine can have mul...
What needs improvement with SAP Adaptive Server Enterprise?
SAP is not putting money into modernizing SAP Adaptive Server Enterprise. One of the things I discovered on the last project I was on was that they did not incorporate the Intel new instruction set...
What is your primary use case for SAP Adaptive Server Enterprise?
I have worked with SAP Adaptive Server Enterprise, SAP Adaptive Server Enterprise IQ, and Replication Server. I also worked with SQL Anywhere at one point. SAP acquired Sybase at one point, and the...
Would you say the price of SQL Server is high compared to that of similar products?
SQL Server is fairly priced because it has various editions, depending on the number of users, servers, or core packs you are using. If you compare the product to others in this category, the price...
Has using SQL Server helped your organization in any way?
SQL Server has helped my organization through partitioning to distribute the workload, as it splits them up into smaller pieces so the machines can easily deal with it. However, this comes with a h...
Which authentication mode is best for SQL Server?
My company connects through SQL Server authentication. We have company Windows accounts, but we do not want to connect the two, out of security concerns and to keep things separated for our own pur...
 

Also Known As

SAP ASE
Microsoft SQL Server, MSSQL, MS SQL
 

Overview

 

Sample Customers

City of Buenos Aires, ASR Group, Citrix, EarlySense, Usha International Limited, Automotive Resources International (ARI), Takisada-Osaka Co. Ltd., Coelba (Grupo Neoenergia), RZD Russian Railways, National Basketball Association - NBA, TALLY
Microsoft SQL Server is used by businesses in every industry, including Great Western Bank, Aviva, the Volvo Car Corporation, BMW, Samsung, Principality Building Society, Wellmark Blue Cross and Blue Shield, and the Catholic District School Board of Eastern Ontario.
Find out what your peers are saying about SAP Adaptive Server Enterprise vs. SQL Server and other solutions. Updated: November 2026.
922,349 professionals have used our research since 2012.