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."The product offers high scalability."
"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."
"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 solution is very fast."
"The solution's ROI is excellent."
"Oracle Database In-Memory is a suite of features that improves performance for real-time analytics and mixed workloads."
"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."
"Having everything in one centralized set of databases is the most valuable feature."
"SQL Server is quite user-friendly. I have experience with Oracle and PostgreSQL, so out of three, I like SQL Server a lot."
"SQL Server is definitely easy to use, and with the volume that we have, it's also stable."
"It's easy to use and fairly intuitive. I do development and data analysis, so we do a lot of work with SSIS and SQL Job Scheduler. Deploying new databases is very simple with things like BACPAC."
"SSAS is the most interesting feature to organize the data and let the users play with it."
"The most valuable feature of SQL Server is that it is easy to set up."
"The solution offers very high performance."
"I have found the whole solution with all its features wonderful."
"We often have to find solutions on our own through the support site, so there's room for improvement in this regard."
"The solution should move to the new way of writing software code with AI that is intelligent and learns."
"The solution is quite expensive."
"Lacks sufficient integration with other tools."
"They should improve the solution's scalability for large databases."
"The product could be more economical."
"Oracle should include column store or advanced query optimization so a database can be optimized by enabling analytic queries to run faster."
"Technical support is below our expectations currently. It could be improved."
"Due to the fact that I'm dealing with the product more as a data analyst, the SQL Server management studio is really relatively primitive compared to other more advanced tools."
"I would like to see more integration with other platforms."
"While this is a reliable product, it has room for improvement."
"There should be more tools and documentation for tuning the performance of Microsoft SQL Server. It would be nice to have more tools for tuning because currently, all the tuning that we have to do with our databases is almost manual. We have to read a bunch of knowledge base articles, and this information should be better documented. Its free text search should also be improved. It is quite important for us. Currently, we're developing our own free text search because of the lacking flexibility in Microsoft SQL Server. Therefore, we're kind of using elastic search and making different implementations in order to reach our targets. Using just the native free text search of Microsoft SQL Server is not enough for us. It should have more flexible features as compared to the current version."
"It pesters you to update the Client every month when there is nothing new that you really need to add, but it is constantly pestering you. I do not care for it."
"It would be better if it had more integration with other systems."
"Other than Synapse and the other version of SQL Server, they face some problems while processing the data."
"The solution is expensive. The licensing costs are high."
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 MariaDB, 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.