We performed a comparison between SAP Adaptive Server Enterprise and SQL Server based on real PeerSpot user reviews.
Find out in this report how the two Relational Databases Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."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."
"It's user-friendly, especially in the logistics field."
"The actual interface is good."
"They provide easy integration with other systems."
"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."
"SAP Adaptive Server Enterprise is a good transactional database."
"Provides very good integration."
"The support from Microsoft has been good."
"The performance is reliable."
"It's a flexible solution."
"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."
"One of the best features of SQL Server is the efficient retrieval of information."
"I have contacted technical support, and overall my experience with technical support was okay."
"The replication feature, user interface, reporting services, and notification services are really good. They are providing SQL profiler and SQLCMD as their integrated software, so we don't find it difficult to integrate any of our third-party applications with MS SQL because all of them support MS SQL very clearly."
"Features like autoscaling, business continuity, and security are beneficial. The tool's compatibility with almost all of the enterprise-class applications is also beneficial for users."
"The solution should improve view partitioning. The documentation is very confined and available only for users. Distributors also would like access to it."
"I think that the solution needs to be positioned better within the market as it appears as though the Adaptive Server is being left out of the SAP scope."
"User interface could be more user friendly."
"Because the solution is customized. we do occasionally face unique bugs. There are always some changes that need to be made here and there."
"SAP should refine its debugging method, and the process needs to be a little faster. It should use more Pragmas and fewer pseudocomments. I would like if SAP added more features based on advanced technologies, like artificial intelligence and voice control. The modularization and if-else techniques could also incorporate the latest technology to code and solve complex problems. The SAP Editor should be more elaborative, and it should allow many more types of statements for all uses."
"There could be some improvements in barcode scanning and RFID access."
"Cost-wise, SAP is still expensive compared to other available products."
"The solution could improve by having more integration with other operating systems and other platforms."
"We need it to support Linux for better troubleshooting flexibility."
"In the next releases, I would only like more enhanced backups and more restore points."
"There should be more tools and documentation for tuning the performance of Microsoft SQL Server. It would be nice to have more tools for tuning because currently, all the tuning that we have to do with our databases is almost manual. We have to read a bunch of knowledge base articles, and this information should be better documented. Its free text search should also be improved. It is quite important for us. Currently, we're developing our own free text search because of the lacking flexibility in Microsoft SQL Server. Therefore, we're kind of using elastic search and making different implementations in order to reach our targets. Using just the native free text search of Microsoft SQL Server is not enough for us. It should have more flexible features as compared to the current version."
"The performance is not always the best."
"I would like to have the option to use fewer processors for certain tasks, thus reducing the licensing fee."
"SQL Server could be more robust than one of its competitors."
"The free version of SQL Server is time-limited before updating to the paid version."
More SAP Adaptive Server Enterprise Pricing and Cost Advice →
SAP Adaptive Server Enterprise is ranked 17th in Relational Databases Tools with 10 reviews while SQL Server is ranked 1st in Relational Databases Tools with 260 reviews. SAP Adaptive Server Enterprise is rated 8.6, while SQL Server is rated 8.4. The top reviewer of SAP Adaptive Server Enterprise writes " Loaded with a lot of features but the price is a drawback ". On the other hand, the top reviewer of SQL Server writes "Easy to use and provides good speed and data recovery". SAP Adaptive Server Enterprise is most compared with SAP HANA, SAP SQL Anywhere, Oracle Database, IBM Db2 Database and SAP IQ, whereas SQL Server is most compared with MariaDB, SAP HANA, Oracle Database and LocalDB. See our SAP Adaptive Server Enterprise vs. SQL Server report.
See our list of best Relational Databases Tools vendors.
We monitor all Relational Databases Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.