Coming October 25: PeerSpot Awards will be announced! Learn more

SQL Server vs Vertica comparison

Cancel
You must select at least 2 products to compare!
Microsoft Logo
22,215 views|16,943 comparisons
Micro Focus Logo
9,030 views|7,035 comparisons
Comparison Buyer's Guide
Executive Summary

We performed a comparison between SQL Server and Vertica 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.

To learn more, read our detailed SQL Server vs. Vertica report (Updated: September 2022).
632,611 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"Similar to Microsoft SQL, it is easy to scale.""SQL Server is widely used and it's simple. You cannot do without Microsoft if you want to manage IT for a business customer.""Most valuable features include: high availability, clustering, save backup and recovery.""I love SQL Server's Common Table Expression. In addition to that, I like its lead and lag functions. That helped us reduce a lot of code when comparing rows in SQL Server.""It is easy to use and very stable.""We have found the solution valuable because we are able to easily create a query, shrink, backup, and make new tables.""The support from Microsoft has been good.""The interface for building the queries or writing the store procedures is good."

More SQL Server Pros →

"Vertica is a columnar database where the query performance is extremely fast and it can be used for real-time integrations for API and other applications. The solution requires zero maintenance which is helpful.""Vertica has a few features that I like. From an architecture standpoint, they have separated compute and storage. So you have low-cost object storage for primary storage and the ability to have several sub-clusters working off the same ObjectStore. So it provides workload isolation.""Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data.""The feature I like best is performance. We use Red Tool and Red Job for the data warehouse and reporting. It's perfect. Performance is good, and it can return ad hoc queries very quickly. Of course, it's a cluster, so it's easy to scale.""I have found the solution to be scalable.""It has improved my organization's functionality and performance.""The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful.""The most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good."

More Vertica Pros →

Cons
"The performance could improve.""The backup capacity needs to be bigger.""Its ability to handle certain kinds of large data could be improved.""It's difficult to make changes. It's a very complicated product in general — that's the issue.""Database support could be improved.""Analysis services have a lot of room for improvement. Basically, manageability on the available tools. They should have improved them already. They are not very efficient. My main headache is with the analysis service, and it would be really good if Microsoft developed some additional tools that are more user-friendly to manage the analysis. This is both from the perspective of management, users' roles, and performance analysis. My main wish for SQL Server would be that management tools for analysis services grow and mature a bit.""It will be very useful to have high-level database monitoring. It should also have built-in business intelligence reporting.""It needs to be improved to handle big data for large volumes of transactions for big industries. As compared to Oracle Database, SQL Server is not suitable for big data or large organizations where the database size could be more than 100 GB or more. In our country, for a large database and a large volume of transactions, we normally use Oracle Database. Most of the large banks are shifting from SQL Server to Oracle Database because of its slowness."

More SQL Server Cons →

"We are looking for a cheaper deployment for the solution. Although we did a lot of benchmarks, like Redshift. We tried Redshift, it didn't work. It didn't work out for us as well.""Support is an area where it could get better.""The integration of this solution with ODI could be improved.""I have found that coding support could be simplified.""Vertica seems to scale well, except for one use case where you are on a multi-node cluster. For example, if you had a nine-node cluster, one node goes down, then the eight nodes don't scale, because the absence of the node is very apparent, which is a problem. If you have nine nodes or multiple nodes, the whole idea is that if one of those nodes goes down, then you should not see an impact on the system if you have enough capacity. Even though we have enough capacity, you can still see the impact of the one node going down.""They could improve the integration and some of the features in the cloud version.""Vertica offers a platform-as-a-service version, but their software-as-a-service solution is only available on AWS. They need to get a SaaS version on Azure and GCP as fast as possible.""Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be."

More Vertica Cons →

Pricing and Cost Advice
  • "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."
  • "The cost is high and because it's an expensive product, we are in the process of moving towards open-source solutions."
  • "It's cheaper than Oracle."
  • More SQL Server Pricing and Cost Advice →

  • "It's difficult today to compete with open-source solutions. In these areas, there is a lot of competition and the price of this solution is a bit pricy."
  • "The price could be cheaper and it is best to negotiate the price."
  • "The price is reasonable. We use a pay per license model. Firstly, you need to buy a license. After that, you mainly pay the annual support fee of around 20% or 25%. I think their prices are quite reasonable."
  • "The pricing could improve, it is a little expensive."
  • "The pricing depends on the license model because there are several. It depends on the client, but it's cheaper than other solutions. I think it's cheap for all the functionality and robustness. It's not very expensive to deploy."
  • "The pricing for this solution is very reasonable compared to other vendors."
  • More Vertica Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
    632,611 professionals have used our research since 2012.
    Questions from the Community
    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.
    Top Answer:The most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good.
    Top Answer:The pricing for this solution is very reasonable compared to other vendors.
    Top Answer:We faced some challenges when trying to use the temporary tables feature. First, we installed Vertica on the AWS cloud and tried to read the data from Bitbucket to Vertica. We were able to read the… more »
    Ranking
    Views
    22,215
    Comparisons
    16,943
    Reviews
    165
    Average Words per Review
    444
    Rating
    8.2
    4th
    out of 30 in Data Warehouse
    Views
    9,030
    Comparisons
    7,035
    Reviews
    10
    Average Words per Review
    496
    Rating
    8.8
    Comparisons
    Also Known As
    Microsoft SQL Server, MSSQL, MS SQL
    Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
    Learn More
    Overview

    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.

    Micro Focus Vertica is the most advanced SQL database analytics portfolio built from the very first line of code to address the most demanding Big Data analytics initiatives. Micro Focus Vertica delivers speed without compromise, scale without limits, and the broadest range of consumption models. Choose Vertica on premise, on demand, in the cloud, or on Hadoop. With support for all leading BI and visualization tools, open source technologies like Hadoop and R, and built-in analytical functions, Vertica helps you derive more value from your Enterprise Data Warehouse and data lakes and get to market faster with your analytics initiatives.

    To learn more about Micro Focus Vertica Advanced Analytics, visit our website.

    Offer
    Learn more about SQL Server
    Learn more about Vertica
    Sample Customers
    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.
    Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
    Top Industries
    REVIEWERS
    Financial Services Firm19%
    Computer Software Company12%
    Manufacturing Company10%
    Government5%
    VISITORS READING REVIEWS
    Computer Software Company18%
    Comms Service Provider15%
    Financial Services Firm10%
    Government6%
    REVIEWERS
    Computer Software Company21%
    Media Company18%
    Marketing Services Firm15%
    Comms Service Provider12%
    VISITORS READING REVIEWS
    Computer Software Company21%
    Comms Service Provider14%
    Financial Services Firm12%
    Manufacturing Company6%
    Company Size
    REVIEWERS
    Small Business42%
    Midsize Enterprise20%
    Large Enterprise37%
    VISITORS READING REVIEWS
    Small Business20%
    Midsize Enterprise15%
    Large Enterprise65%
    REVIEWERS
    Small Business32%
    Midsize Enterprise26%
    Large Enterprise42%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise14%
    Large Enterprise70%
    Buyer's Guide
    Relational Databases Tools
    September 2022
    Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools. Updated: September 2022.
    632,611 professionals have used our research since 2012.

    SQL Server is ranked 1st in Relational Databases Tools with 165 reviews while Vertica is ranked 4th in Data Warehouse with 11 reviews. SQL Server is rated 8.2, while Vertica is rated 8.8. The top reviewer of SQL Server writes "Good performance, well-priced, trivial to set up, and helpful support". On the other hand, the top reviewer of Vertica writes "Enhanced capabilities, good customer service, large data scalability and stable". SQL Server is most compared with Oracle Database, SAP HANA, LocalDB, MariaDB and SAP SQL Anywhere, whereas Vertica is most compared with Snowflake, Teradata, Amazon Redshift, Oracle Exadata and Microsoft Azure Synapse Analytics.

    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.