Compare SAP HANA vs. SQL Server

Cancel
You must select at least 2 products to compare!
SAP HANA Logo
10,650 views|8,545 comparisons
SQL Server Logo
23,223 views|18,888 comparisons
Most Helpful Review
Find out what your peers are saying about SAP HANA vs. SQL Server and other solutions. Updated: January 2021.
464,757 professionals have used our research since 2012.
Quotes From Members

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

Pros
"It has a very huge bandwidth and data transfer.""This solution is very fast.""If you want to scale with new processes and new reports, that's fairly easy.""The most value for us was in terms of using it to issue tenders online. We host our server, but it is open to the public, so clients who want to buy those tenders were able to go online, put their tender documents up, and we could evaluate them using SAP.""Integration is the most valuable feature we use SAP HANA for.""One feature I find very valuable, is the response time of the application on the database memory.""The functionality is of the solution is very good.""The data storage requirement is reduced from the original database to the HANA database."

More SAP HANA Pros »

"It is one of the most stable relational databases out there.""The most valuable feature is replication because we had several replicas of the SQL Server database in different geographical locations.""The availability is the most valuable feature. It has high availability. It also has good performance.""SQL is very easy to manage.""It helps with moving the design of the database into reality.""The feature that I have found most valuable is that it is easy to code.""Very good security features.""The features that we have found the most valuable are reliability, availability perspective, and current scalability."

More SQL Server Pros »

Cons
"The solution is very expensive, however. The pricing depends on the number of users and many other factors that affect licensing.""The inclusion of a well-performing Time Machine is vital.""In terms of improvement, the speed is not as good as we thought it would be. That is why we are trying different solutions that will be built with different technologies.""The interface is a little bit hard to customize. You almost have to consult the SAP original developer to change it.""FI, or the financial module of SAP, has room for improvement. It has to have some better localization for the Middle East, especially in regards to taxes and the letter of credit cycle. I would like to see better localization from the HCM.""If the developers were to enhance or improve the application logic while processing the transactions, that would be great.""The challenge right now is all databases are on S4 HANA architecture. You're running it for HANA, but not all the functionalities are available. If they can speed up getting all the databases on S4 HANA that would help.""I think that the pricing is high and it needs improvement."

More SAP HANA Cons »

"I would like to see native plugins built for other platforms versus having to buy third-party plugins to tap into S3 buckets and AWS Cloud. Right now, it does not have those built-in plugins.""I would like to have more replication scenarios.""In terms of improvement, it could use more integration with other products.""Occasionally the performance, as good as it is, is a bit off. We sometimes experience memory spiking. If they could maybe fix that aspect of the solution, that would be quite helpful for our organization.""The product overall would benefit from the addition of better tutorials to help master the skills necessary to actually build a project database. Right now, what is available isn't sufficient.""In terms of what could be improved, everything on-premise is now moving to the cloud. Obviously SQL Server has also moved, because Microsoft Excel has its own cloud called Azure Finance. Every solution comes with its own advantages and disadvantages.""Query optimitzer could be simplified.""The scalability and the high availability feature can be expanded or improved. Currently, there is a limitation on scalability. A feature similar to the Oracle Diagnostic feature can be included to provide a better user experience."

More SQL Server Cons »

Pricing and Cost Advice
"People who are technical will accept the cost, but financially they will assess whether this solution will bring them revenue or not. People often ask, how will I profit when the cost is so high?""It is expensive, which isn't a problem for us because SAP HANA is processing the data so fast.""SAP HANA is an expensive product.""It is expensive.""Setup and licensing require planning and proper budgeting, as it is not cheap.""The price of the solution could be reduced, it is expensive."

More SAP HANA Pricing and Cost Advice »

"It is expensive, but you get what you pay for.""Since we are a cloud-based company, there is AWS pricing on top of the SQL Server pricing. The Enterprise Edition can typically sell from around $1000 dollars a month, which is not cheap. Then, there is an additional one-time Windows cost, based on the code, which can go anywhere from $30,000 to $40,000 for the license.""SQL Server is a cost-effective solution for a small database.""Pricing is reasonable for small organizations, but the scaling increases the price.""We didn't have any licensing costs for SQL Server.""We pay approximately $12,000 USD per month for both the server and the license.""The price could be cheaper.""Cost is a major derivative for any organization. It has a reasonable cost value, and its cloud support is also better than others. Comparatively, Oracle can do the same things or is even better in certain areas, but it is expensive. The cost along with the support are the plus factors for SQL Server."

More SQL Server Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Relational Databases solutions are best for your needs.
464,757 professionals have used our research since 2012.
Answers from the Community
Aashutosh Sharma
author avatarTs Nurul Haszeli
Real User

It really depends on the purpose of usage. Both have strengths and limitations. SAP HANA is expensive especially when you try to integrate data from other sources than SAP systems. SQL Server (I believed you refer to MSSQL), is good for you to store application data. However, if you need big data analysis or advanced analytics, SQL Server may not be the best solution. The same goes for SAP HANA.

Questions from the Community
Top Answer: It really depends on the purpose of usage. Both have strengths and limitations. SAP HANA is expensive especially when you try to integrate data from other sources than SAP systems. SQL Server (I… more »
Top Answer: The availability is the most valuable feature. It has high availability. It also has good performance.
Top Answer: In terms of improvement, it could use more integration with other products.
Top Answer: My primary use case is for data mining and processing data from plants. It's normally just for databases for the systems.
Ranking
4th
Views
10,650
Comparisons
8,545
Reviews
22
Average Words per Review
505
Rating
8.0
1st
Views
23,223
Comparisons
18,888
Reviews
36
Average Words per Review
531
Rating
8.3
Popular Comparisons
Also Known As
SAP High-Performance Analytic Appliance, HANA
Microsoft SQL Server, MSSQL, MS SQL
Learn More
Overview

The SAP HANA® platform helps you reimagine business by combining a robust database with services for creating innovative applications. It enables real-time business by converging trans-actions and analytics on one in-memory platform. Running on premise or in the cloud, SAP HANA untangles IT complexity, bringing huge savings in data management and empowering decision makers everywhere with new insight and predictive power.

SQL Server is the Microsoft-driven relational database management system. This system is used to store data as well as retrieve it when necessary; these functions can be supported by individual users or by multiple users within a larger network. The Microsoft SQL Server has warehousing options, quality and integration services, management tools that are simple to implement, as well as robust tools for development.

Looking at the more technical end of things, Microsoft SQL Server uses query languages such as T-SQL and ANSI SQL. Disaster recovery is one of the product's most prominent features, in addition to in-memory performance, scalability, and corporate business intelligence capabilities.

Offer
Learn more about SAP HANA
Learn more about SQL Server
Sample Customers
Unilever, NHS 24, adidas Group, CHIO Aachen, Hamburg Port Authority (HPA), Bangkok Airways Public Company Limited
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.
Top Industries
REVIEWERS
Energy/Utilities Company16%
Financial Services Firm11%
Consumer Goods Company11%
Recruiting/Hr Firm5%
VISITORS READING REVIEWS
Computer Software Company39%
Comms Service Provider18%
Manufacturing Company6%
Media Company5%
REVIEWERS
Computer Software Company16%
Financial Services Firm14%
Manufacturing Company8%
Transportation Company8%
VISITORS READING REVIEWS
Computer Software Company28%
Comms Service Provider20%
Media Company6%
Financial Services Firm6%
Company Size
REVIEWERS
Small Business35%
Midsize Enterprise10%
Large Enterprise55%
REVIEWERS
Small Business35%
Midsize Enterprise25%
Large Enterprise40%
Find out what your peers are saying about SAP HANA vs. SQL Server and other solutions. Updated: January 2021.
464,757 professionals have used our research since 2012.

SAP HANA is ranked 4th in Relational Databases with 23 reviews while SQL Server is ranked 1st in Relational Databases with 36 reviews. SAP HANA is rated 8.0, while SQL Server is rated 8.4. The top reviewer of SAP HANA writes "Very robust solution with good data access". On the other hand, the top reviewer of SQL Server writes "A stable, scalable, and easy-to-deploy solution that pretty much covers everything". SAP HANA is most compared with Oracle Database, MySQL, Apache Spark, Oracle Database In-Memory and IBM Db2 Database, whereas SQL Server is most compared with Oracle Database, Teradata, IBM Db2 Database, MariaDB and LocalDB. See our SAP HANA vs. SQL Server report.

See our list of best Relational Databases vendors.

We monitor all Relational Databases 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.