IT Central Station is now PeerSpot: Here's why

SAP HANA vs SQL Server comparison

Cancel
You must select at least 2 products to compare!
SAP Logo
13,643 views|8,102 comparisons
Microsoft Logo
20,336 views|15,716 comparisons
Featured Review
Buyer's Guide
SAP HANA vs. SQL Server
May 2022
Find out what your peers are saying about SAP HANA vs. SQL Server and other solutions. Updated: May 2022.
609,272 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
"We have found the solution to be customizable and it is beneficial it comes as a bundled package. Additionally, it is user-friendly.""The in-memory computing and the efficient response time are very good features.""We like that the product is both vertically and horizontally scalable, allowing us to do around 86 percent compression of documentation from 50 to seven terabytes.""What I like most are the dashboards and pervasive analytics.""The solution is easy to scale.""The performance is very, very good. It's one of the best aspects of the solution.""The solution operates well.""SAP HANA is vertically and horizontally scalable."

More SAP HANA Pros →

"The columnstore index feature is useful for us, and we also use the integration services. It is also very stable.""We found it to be quite scalable.""The security and vulnerability management are well-managed through the vendor.""The most valuable features of this solution are easy queries and straightforward programming for beginners.""The pricing of the solution is okay. It's less expensive than Oracle, for example.""I like that the new version has a memory-optimized table to improve the performance.""It is stable, and it works okay.""In Poland, SQL Server is the most popular database engine, and overall, our customers like it."

More SQL Server Pros →

Cons
"SAP HANA is not strong like Oracle when it comes to finance. They are only strong with the logistic business project.""There could be better management for faster updates, last year there were some changes in India to the e-invoicing feature.""They can improve their technology for the CRM subsystem. There are other products that are better and more effective for the CRM subsystem. Its price could be better. It is expensive.""SAP HANA is a very proprietary tool and there's not as much support available for it as there is for an SQL Server (which is more popular).""The worst thing about SAP HANA is the price; it's very expensive. The licensing cost, implementation cost, hosting cost, and appliance cost are all high.""SAP HANA is not perfect and they could improve by having more options and more integration.""Uses a large amount of RAM and is costly.""The product lacks some flexibility in its settings and configurations."

More SAP HANA Cons →

"Better integration with other platforms would be an improvement.""I am fine with the pricing, but pricing is an area that can always be improved.""The remote access aspect needs to be improved in terms of security.""Microsoft doesn't have active-active load balancing scenarios. It's always a failover cluster.""Database support could be improved.""I would like the SQL Server to be able to provide cloud support. We use the solution with a Korean provider supporting only MySQL rather than Microsoft SQL Server, which would be preferable and cheaper. This would prevent us from having to pay for troubleshooting and hosting the server.""The performance could improve.""When we are talking about event space architecture, scalability generally comes into play. For example, I might have a hundred thousand transactions a second, and then all of a sudden, I build something that everybody in the world wants. The next thing I know is that I have a million transactions a second. So, to be able to process the throughput, I'd have to scale up, and then when the holidays are over, I'm again down to a hundred thousand transactions, and I want to scale back down. SQL Server is not going to do that. In this way, it is not very scalable. One of the reasons why they want us to use Kafka is so that if we need to, we can do that, but our base program is on SQL Server. So, this is where we would use a Kafka event stack so that if I need more servers, I can just write a command, and I can have more consumers, more brokers, and more producers, and when the holiday season is over, it scales right back down again. SQL Server is not going to do that."

More SQL Server Cons →

Pricing and Cost Advice
  • "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."
  • "The price of this product is good."
  • "We pay $200 on a monthly basis."
  • "The price is high and could be a bit cheaper."
  • More SAP HANA Pricing and Cost Advice →

  • "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."
  • "We have had to purchase the Enterprise version to the tune of a few hundred thousand dollars, which is just ridiculous."
  • "With recent releases, the Standard Edition (cheaper) SKU has some of the earlier version Enterprise features. SQL Express has some limitations."
  • More SQL Server Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Relational Databases solutions are best for your needs.
    609,272 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:It's user-friendly so long as you use it frequently.
    Top Answer:The licensing is typically chared yearly. It was rather expensive.
    Top Answer:Some production features are lacking. For example, we cannot see any dashboards in the production department. The generation of reports needs to be better. We have sales reports and yet no production… more »
    Top Answer:We're satisfied with the stability.
    Top Answer:Performance-wise, SQL cannot handle large amounts of data. In the next release, I would like them to commission SQL Server on Linux, as has been announced in the past but has not yet happened.
    Ranking
    4th
    Views
    13,643
    Comparisons
    8,102
    Reviews
    27
    Average Words per Review
    474
    Rating
    8.0
    1st
    Views
    20,336
    Comparisons
    15,716
    Reviews
    172
    Average Words per Review
    451
    Rating
    8.2
    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 Company21%
    Financial Services Firm10%
    Retailer7%
    Pharma/Biotech Company7%
    VISITORS READING REVIEWS
    Computer Software Company28%
    Comms Service Provider19%
    Manufacturing Company8%
    Energy/Utilities Company6%
    REVIEWERS
    Financial Services Firm19%
    Computer Software Company12%
    Manufacturing Company10%
    Government5%
    VISITORS READING REVIEWS
    Computer Software Company22%
    Comms Service Provider22%
    Financial Services Firm8%
    Government6%
    Company Size
    REVIEWERS
    Small Business33%
    Midsize Enterprise11%
    Large Enterprise57%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise16%
    Large Enterprise68%
    REVIEWERS
    Small Business43%
    Midsize Enterprise20%
    Large Enterprise37%
    VISITORS READING REVIEWS
    Small Business20%
    Midsize Enterprise16%
    Large Enterprise64%
    Buyer's Guide
    SAP HANA vs. SQL Server
    May 2022
    Find out what your peers are saying about SAP HANA vs. SQL Server and other solutions. Updated: May 2022.
    609,272 professionals have used our research since 2012.

    SAP HANA is ranked 4th in Relational Databases with 29 reviews while SQL Server is ranked 1st in Relational Databases with 172 reviews. SAP HANA is rated 8.0, while SQL Server is rated 8.2. 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 "Good performance, well-priced, trivial to set up, and helpful support". SAP HANA is most compared with Oracle Database, MySQL, IBM Db2 Database, Apache Spark and Oracle Database In-Memory, whereas SQL Server is most compared with Oracle Database, LocalDB, IBM Db2 Database, MariaDB and MySQL. 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.