Oracle Database In-Memory vs SQL Server comparison

Cancel
You must select at least 2 products to compare!
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Oracle Database In-Memory 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.
To learn more, read our detailed Oracle Database In-Memory vs. SQL Server Report (Updated: November 2022).
655,113 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
"The most valuable feature is that Database-In-Memory is more consistent and faster than traditional databases as it requires fewer CPUs to process instructions.""The on-premise version is stable. We have different teams and resources for the server side, for admin, and for development. We can easily take care of all the services and applications.""Security is the most valuable feature."

More Oracle Database In-Memory Pros →

"It's much more friendly in comparison with Oracle.""As a data warehouse and storage solution, it's quite good.""It's great that the database engine is always on.""The installation is pretty straightforward.""We're satisfied with the stability.""The pricing of the solution is okay. It's less expensive than Oracle, for example.""SQL Server is a very mature solution.""The solution is very common. It's easy to use."

More SQL Server Pros →

Cons
"Lacks sufficient integration with other tools.""Oracle should include column store or advanced query optimization so a database can be optimized by enabling analytic queries to run faster.""The query optimization and backup features should be added."

More Oracle Database In-Memory Cons →

"The solution is rather expensive.""It may be a licensing issue, but sometimes its operating speed becomes slow if we have multiple users. It's lacking some performance, but it's acceptable because we have a heavy load.""More things in SQL Server need to be automated.""Our biggest problem with SQL Server is latency. The communication between the cloud and the on-premises environment is slow. The data needs to be encrypted for security, and you have to exchange data certificates between environments. You can adjust the configuration to improve performance, but it would be nice if SQL Server had some templates to resolve problems.""I would like Microsoft to evolve SQL Server because stateful databases dying are in a way. We would like to find out if it can absorb Hadoop and other similar things. They should make it useful for data mining. Data is evolving forever, and how we store it is also changing constantly. So, SQL Server also needs to change.""The interface could be updated to make it slightly more user-friendly.""The configuration process can be a little complex.""The remote access aspect needs to be improved in terms of security."

More SQL Server Cons →

Pricing and Cost Advice
  • "Database In-Memory is priced a bit higher than its competitors like Microsoft."
  • More Oracle Database In-Memory Pricing and Cost Advice →

  • "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."
  • "We're looking at alternative solutions because we think Microsoft's licensing costs have been expensive."
  • More SQL Server Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
    655,113 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:The application development is very user-friendly.
    Top Answer:The product is quite expensive. Organizations should be prepared for a rather high price tag. Our clients may end up moving to an open-source option to lower costs.
    Top Answer:The pricing could be improved. It would ideal if it was more reasonable. The design isn't that great. It's kind-of buggy and doesn't seem to cater to the Korean market. There seems to be issues… more »
    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: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 »
    Ranking
    Views
    2,820
    Comparisons
    2,225
    Reviews
    3
    Average Words per Review
    305
    Rating
    8.3
    Views
    25,896
    Comparisons
    19,266
    Reviews
    163
    Average Words per Review
    446
    Rating
    8.2
    Comparisons
    Also Known As
    Microsoft SQL Server, MSSQL, MS SQL
    Learn More
    Overview

    Oracle Database In-Memory transparently accelerates analytics by orders of magnitude while simultaneously speeding up mixed-workload OLTP. With Oracle Database In-Memory, users get immediate answers to business questions that previously took hours.

    Oracle Database In-Memory delivers leading-edge in-memory performance without the need to restrict functionality, or accept compromises, complexity and risk. Deploying Oracle Database In-Memory with any existing Oracle Database compatible application is as easy as flipping a switch - no application changes are required. Oracle Database In-Memory is fully integrated with the Oracle Database’s renowned scale-up, scale-out, storage tiering, availability, and security technologies making it the most industrialstrength offering on the market.

    The ability to easily perform real-time data analysis together with real-time transaction processing on all existing applications enables organizations to transform into Real-Time Enterprises that quickly make data-driven decisions, respond instantly to customer demands, and continuously optimize all key processes.

    For more information on Oracle Database In-Memory, visit Oracle.com

    SQL Server is a relational database management system (RDBMS) by Microsoft. The product's main purposes are to store data and retrieve it as requested by other software applications - on the same computer or on another computer across a shared network. The solution is built on top of Structured Query Language (SQL), which is a standardized programming language used for relational database management.

    The product is tied to Transact-SQL (T-SQL), which is an implementation of SQL from Microsoft that adds several proprietary programming extensions to the standard language. SQL Server is built similarly to other RDBMS products, as its structure is a row-based table that connects related data elements in different tables to one another. One of its most important components is the SQL Server Database Engine, as it controls data processing, storage, and security. Beneath the Database Engine is the SQL Server Operating System, which is used for memory and I/O management, locking data to avoid unneeded upgrades, and job scheduling.

    The solution has four editions with different sets of services and tools. They include:

    • SQL Server Developer
    • SQL Server Expression
    • SQL Server Standard 
    • SQL Server Enterprise

    The first two are available for free and are typically utilized by smaller companies, as they work with fewer functions and storage. The second two editions are generally used by bigger organizations and enterprises and offer more features.

    The solution has several functions through which users can facilitate different data-related processes. These include:

    • Aggregate functions: These functions are used to calculate one or more values and return a single value.

    • Window functions: Window functions calculate an aggregate value based on a group of rows and return multiple rows for each involved group.

    • Date functions: These functions allow clients to handle data and time data efficiently.

    • String functions: Through the string functions, SQL Server processes an input string and returns a string or numeric value.

    • System functions: The system functions of the product return objects, values, and settings.

    SQL Server Services

    SQL Server has a wide range of add-on services that provide additional benefits beyond database management. These services include:

    • Machine learning: SQL Server machine learning services allow users to do machine learning and data analytics within the product.
       
    • Service broker: This feature is a part of the database engine and offers messaging and message queuing for applications on the platform.

    • Replication: This feature consists of transaction replication, merge replication, and snapshot replication. 

    • Analysis: SQL Server Analysis Services (SSAS) adds online analytical processing (OLAP) and data mining capabilities to SQL Server databases.

    • Reporting: This feature supports the development of custom reporting applications.

    • Notifications: This feature generates data-driven notifications which are sent to subscribers of Notification Services.

    • Integration: This SQL Server feature provides capabilities for data integration, data import, and data warehousing.

    • Full-text search: Through this feature, users can utilize specialized indexing and query for unstructured text stored in the solution.

    • Visual studio: This feature supports data programming with SQL Server.

    • Azure Data Studio: This is a cross-platform query editor that can be downloaded and used alongside SQL Server.

    SQL Server Benefits

    The solution has many benefits for users. These include the following:

    • The platform ensures a consistent experience across other platforms while being fast and agile.

    • Through the built-in intelligence features, users can understand their data better.

    • The solution has enterprise-level security, which ensures the smooth and safe performance of users' data.

    • SQL Server offers the ability to retrieve large amounts of data quickly and efficiently.

    • The product installation process is fairly easy, and it offers a user-friendly interface.

    • SQL Server offers improved data storage and retrieval functions through frequent upgrades.

    • The solution reduces the risk of database server attacks, since it is not an open-source database.

    Reviews from Real Users

    A president at a consultancy evaluates SQL Server as a veteran solution with critical log shipping feature

    Harkamal S., a user at a manufacturing company, rates SQL Server with a high mark because it is a stable, scalable, and easy-to-deploy solution that pretty much covers everything.

    Offer
    Learn more about Oracle Database In-Memory
    Learn more about SQL Server
    Sample Customers
    Shanghai Customs
    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
    Financial Services Firm18%
    Local Government9%
    Retailer9%
    Insurance Company9%
    VISITORS READING REVIEWS
    Computer Software Company23%
    Financial Services Firm16%
    Comms Service Provider14%
    Government6%
    REVIEWERS
    Financial Services Firm19%
    Computer Software Company12%
    Manufacturing Company10%
    Government5%
    VISITORS READING REVIEWS
    Computer Software Company18%
    Comms Service Provider13%
    Financial Services Firm11%
    Government6%
    Company Size
    REVIEWERS
    Small Business24%
    Midsize Enterprise18%
    Large Enterprise59%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise12%
    Large Enterprise72%
    REVIEWERS
    Small Business42%
    Midsize Enterprise20%
    Large Enterprise37%
    VISITORS READING REVIEWS
    Small Business20%
    Midsize Enterprise14%
    Large Enterprise65%
    Buyer's Guide
    Oracle Database In-Memory vs. SQL Server
    November 2022
    Find out what your peers are saying about Oracle Database In-Memory vs. SQL Server and other solutions. Updated: November 2022.
    655,113 professionals have used our research since 2012.

    Oracle Database In-Memory is ranked 14th in Relational Databases Tools with 3 reviews while SQL Server is ranked 1st in Relational Databases Tools with 163 reviews. Oracle Database In-Memory is rated 8.4, while SQL Server is rated 8.2. The top reviewer of Oracle Database In-Memory writes "On-premises solution provides security for BFSIs and banking systems". On the other hand, the top reviewer of SQL Server writes "Good performance, well-priced, trivial to set up, and helpful support". Oracle Database In-Memory is most compared with SAP HANA, Progress OpenEdge RDBMS, MySQL, IBM Db2 Database and MariaDB, whereas SQL Server is most compared with Oracle Database, LocalDB, SAP HANA, MariaDB and MySQL. See our Oracle Database In-Memory 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.