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."Oracle Database In-Memory is a suite of features that improves performance for real-time analytics and mixed workloads."
"The product offers high scalability."
"The solution is very fast."
"It efficiently handles low-code data and supports read-and-write operations for clustering."
"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."
"The most valuable aspects of this solution are the fast caching and improved performance to the database"
"We use the tool for real-time data transfer for risk management purposes. In a trading system, conversions happen fast. We use the product to handle fast transactions with low latency."
"It accelerates query processing, which in turn speeds up operations and streamlines workflow, and ultimately enhancing productivity."
"SQL Server is a very mature solution."
"Backups hardly get corrupt."
"The initial setup isn't overly complex."
"The solution is configurable."
"SQL Server Profiler makes finding and debugging easy."
"It is easy to deploy and easy to maintain."
"I have seen that this is a very stable product."
"I believe Always On is the most valuable feature. It's also easy to use and not very tricky."
"The product could be more economical."
"The solution is quite expensive."
"Lacks sufficient integration with other tools."
"The pricing could be improved. It would ideal if it was more reasonable."
"I would like Oracle Database In-Memory to include a data replication feature."
"Oracle Database In-Memory appliance-based solutions can be restrictive for some applications, as they may require more flexibility in the database design to be tuned and sized to the customer's needs."
"It would be good if Oracle could reduce downtime when transferring from non-In-Memory to In-Memory."
"The query optimization and backup features should be added."
"I do not think SQL Server is suited for a typical database warehouse environment. However, people do use SQL Server for data warehouse environments but the best use case is for very small databases. If somebody wants to store more than 10 TB of data querying then the performance really degrades. The performance should be improved in the future to allow more scalability."
"The only item which I can list is application failure during Integration Services debugging, when restarting a process flow. In a number of instances the solutions fails. I have not given this much thought and simply stop and start the debugging service rather than restarting."
"It would definitely be better if SQL Server were free."
"Improvements to the indexing, columnstore indexing, and high availability groups are good improvements for future versions."
"The solution's stability can be improved."
"Maintenance of the solution is an area of concern, and improvements can be helpful."
"There is a lot of room for improvement when it comes to limited compatibility across the platform and restricted performance with massive data sets."
"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."
Oracle Database In-Memory is ranked 8th in Relational Databases Tools with 27 reviews while SQL Server is ranked 1st in Relational Databases Tools with 260 reviews. Oracle Database In-Memory is rated 8.8, while SQL Server is rated 8.4. The top reviewer of Oracle Database In-Memory writes "User friendly with great scalability but needs to move toward intelligent AI". On the other hand, the top reviewer of SQL Server writes "Easy to use and provides good speed and data recovery". Oracle Database In-Memory is most compared with SAP HANA, IBM Db2 Database, Progress OpenEdge RDBMS, MariaDB and Apache Derby, whereas SQL Server is most compared with MariaDB, SAP HANA, Oracle Database, LocalDB and IBM Db2 Database. 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.