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."
"It accelerates query processing, which in turn speeds up operations and streamlines workflow, and ultimately enhancing productivity."
"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."
"I like Oracle because it is a backward-compatible solution."
"It efficiently handles low-code data and supports read-and-write operations for clustering."
"The most valuable aspects of this solution are the fast caching and improved performance to the database"
"The scalability is very good."
"The solution's ROI is excellent."
"It is a simple query language. It is consistent across all versions. If you start with an older version, move to the newer version. The same code will still work."
"The most valuable aspect of the solution is that it's integrated with the Visual Studio and also with Microsoft SQL Server Management Studio. It's a tool they have and it's quite easy to use and understand. It's the interface for programming for SQL Services."
"The solution is easy to use."
"It's great that the database engine is always on."
"We found it to be quite scalable."
"The product can scale if a company needs it to."
"I believe Always On is the most valuable feature. It's also easy to use and not very tricky."
"The solution has proven to be very stable."
"The solution is quite expensive."
"They should lower the price. My customers think that it's too expensive."
"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."
"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."
"The product could be more economical."
"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."
"Lacks sufficient integration with other tools."
"It will be very useful to have high-level database monitoring. It should also have built-in business intelligence reporting."
"While using it, we really didn't experience any pain points."
"We experience latency at times when there is a lot of data being processed."
"Its support for JSON should be improved. It does support JSON, but the support is not good enough currently. They should also improve the way indexes work. Its performance can also be improved because sometimes it becomes very slow for certain table designs. It cannot have more than a certain amount of data. As compared to other databases, its capability to handle large volumes of data is not very good."
"The interface of the tool has certain shortcomings, making it an area where improvements are required."
"The user interface and the reporting could also be improved."
"SQL Server could improve by having better usability or user guidance."
"The documentation could be much better. It's lacking right now. If there are better help pages, for even complicated queries and stuff like that that would be quite a help for users."
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, Apache Derby and kdb+, 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.