We just raised a $30M Series A: Read our story

Compare Oracle Database In-Memory vs. SQL Server

Cancel
You must select at least 2 products to compare!
Top Review
Find out what your peers are saying about Oracle Database In-Memory vs. SQL Server and other solutions. Updated: September 2021.
541,108 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
"Normally, every database server uses hard disks. In-Memory has a feature, apart from their database, which is very good. When we start our server, all your data needs loading memory. We can use that. It's a very good feature. I think they added this feature in 2019. We can mount memory in the partition, create partitions in there, and create table space from that spot to share. It's a really good feature. We use it a lot.""The solution is very fast.""The scalability of the solution is very good. It's able to support large amounts of data.""The most valuable aspects of this solution are the fast caching and improved performance to the database""The application development is very user-friendly."

More Oracle Database In-Memory Pros »

"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.""The latest version supports for big data analytics. SQL Server's vector processing-based batch execution mode is now available to the entire execution of R or Python code. Since much of the work that tends to be done in R and Python involves aggregation, batch mode - which processes rows of data several at a time, can be very helpful.""SQL Server is a stable product."

More SQL Server Pros »

Cons
"We use some partitions in In-Memory. We have a very large table and a low dose. It is very expensive in data to load all of them into In-Memory. It takes up more memory slots in the server, as well as a lot of RAM. We use last partitions on the table. We always need to create a script and make a schedule that can load a last partition in In-Memory. Oracle doesn't have features to do this automatically. I would like them to allow us to load last partitions, as well as other table partitions, in In-Memory. I think a good feature would do that automatically, letting you see a table, load a large partition, and monitor loading memory. It's quite a good feature.""The solution is quite expensive.""Technical support is below our expectations currently. It could be improved.""They should lower the price. My customers think that it's too expensive.""The pricing could be improved. It would ideal if it was more reasonable."

More Oracle Database In-Memory Cons »

"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.""CAL licenses should cost less. Microsoft usually prices high for client access licenses. Server plus user client access license (CAL) licensing requires a separate Server license for each server on which the software is installed, plus a user CAL for each user accessing the server.""The number of concurrent users is too limited and other databases are better than SQL in this regard."

More SQL Server Cons »

Pricing and Cost Advice
Information Not Available
"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.
541,108 professionals have used our research since 2012.
Questions from the Community
Ask a question

Earn 20 points

Top Answer: The ease of administration, in general, is the solution's most valuable aspect.
Top Answer: The licensing cost varies widely, depending upon what methodology you employ. It could be very cheap, for example, it could be less than $2,000. Alternatively, it can go up to well over $100,000.
Top Answer: Its ability to handle certain kinds of large data could be improved. Its high availability, segmentation, and disaster recovery features can be improved upon also. There are not really any significant… more »
Ranking
9th
Views
2,461
Comparisons
2,014
Reviews
5
Average Words per Review
438
Rating
8.2
1st
Views
20,256
Comparisons
15,603
Reviews
115
Average Words per Review
447
Rating
8.3
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 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 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 Firm11%
Local Government11%
Retailer11%
Insurance Company11%
VISITORS READING REVIEWS
Computer Software Company33%
Comms Service Provider22%
Financial Services Firm9%
Government6%
REVIEWERS
Financial Services Firm19%
Computer Software Company11%
Manufacturing Company9%
Transportation Company5%
VISITORS READING REVIEWS
Computer Software Company25%
Comms Service Provider22%
Financial Services Firm8%
Insurance Company5%
Company Size
REVIEWERS
Small Business29%
Midsize Enterprise14%
Large Enterprise57%
REVIEWERS
Small Business44%
Midsize Enterprise20%
Large Enterprise36%
VISITORS READING REVIEWS
Small Business19%
Midsize Enterprise9%
Large Enterprise72%
Find out what your peers are saying about Oracle Database In-Memory vs. SQL Server and other solutions. Updated: September 2021.
541,108 professionals have used our research since 2012.

Oracle Database In-Memory is ranked 9th in Relational Databases with 5 reviews while SQL Server is ranked 1st in Relational Databases with 117 reviews. Oracle Database In-Memory is rated 8.2, while SQL Server is rated 8.2. The top reviewer of Oracle Database In-Memory writes "Easy to deploy and has good performance". On the other hand, the top reviewer of SQL Server writes "A stable, scalable, and easy-to-deploy solution that pretty much covers everything". Oracle Database In-Memory is most compared with SAP HANA, MariaDB, IBM Db2 Database, Progress OpenEdge RDBMS and Exasol, whereas SQL Server is most compared with SAP HANA, Oracle Database, IBM Db2 Database, LocalDB and Teradata. See our Oracle Database In-Memory 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.