We performed a comparison between Oracle Multitenant 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."It's easy to use and works great."
"Maintaining databases is a valuable feature for us."
"You can scale the solution as needed."
"The best thing about Oracle Multitenant is its ability to consolidate multiple databases into one engine."
"The feature that I like on Multitenant is the ease - it is very easy for my team to run the database."
"The most valuable features are the speed and ease of use."
"The database becomes pluggable. Inside this container is called a pluggable database and each application contains this pluggable database inside Multitenant. We can then share resources like control files, memory, etc. This lets you stop and start each application without impacting the others. This resource sharing is the most valuable feature"
"Multitenant has a container database with many pluggable databases."
"It is quite reliable in cluster configurations and has helped me to reduce downtime and improve SLAs."
"The most valuable feature would most likely be querying. We query a lot, we use a lot of stored procedures. As for other features, such as replication and all other more fancy features we don't use them the most. I do not know, but perhaps the DBAs would be the best people who know of the features that they use, but as far as how I use it, it's just for querying and running stored procedures. We use the bare minimum features."
"What I like most is the management, as it is very easy compared with other products."
"SQL Server is widely used and it's simple. You cannot do without Microsoft if you want to manage IT for a business customer."
"I have found SQL Server easy to use."
"We're satisfied with the stability."
"There was an online system in which we had about 2500 requests to the DB per second. Every request had a completion window of one second to process and retrieve data. After switching to SQL Server, and AlwaysOn, and Snapshot, and tinkering, and configuring and tinkering, the handling capacity we measured increased to about 5000 requests per second, while the time decreased to 0.5 seconds per request."
"The solution is easy to use."
"Technical support could be faster."
"That said, Oracle in general doesn't invest in their UI for any of their applications. If we're talking about the dashboard or other user experience, there is room for improvement. I'm talking about on premises. The cloud version has started to improve."
"While the product is overall excellent, it is quite expensive."
"It can be complicated to scale up the solution, but it's scalable."
"It would be beneficial to include this solution with Oracle Enterprise, but Oracle charges additional fees for it."
"The solution lacks a GUI for commands."
"The user interface for this solution can be made better."
"This solution is a bit complicated when collecting from containers - that feature should be a bit better."
"When we run into problems, it's usually during installation, and finding answers to the problem has been a nightmare because the documentation is terrible."
"I would like to see more integration with other platforms."
"In terms of improvement, it could use more integration with other products."
"Database support could be improved."
"SQL Server has good performance, but it could be better."
"As a software developer, it can be hard to do something in Oracle that is SQL Server specific, and vice-versa, sometimes."
"I would say that people should know how to get a SQL setup in place since it might be an area where they lack when it comes to the solution."
"An area for improvement would be the SQL Server process monitoring, which is quite basic and could sustain more information."
Oracle Multitenant is ranked 16th in Relational Databases Tools with 15 reviews while SQL Server is ranked 1st in Relational Databases Tools with 260 reviews. Oracle Multitenant is rated 8.4, while SQL Server is rated 8.4. The top reviewer of Oracle Multitenant writes "Databases are automatically upgraded and cloning of pluggable databases requires just one command ". On the other hand, the top reviewer of SQL Server writes "Easy to use and provides good speed and data recovery". Oracle Multitenant is most compared with Oracle Database, MySQL, IBM Db2 Database and SAP HANA, whereas SQL Server is most compared with MariaDB, SAP HANA, Oracle Database, LocalDB and IBM Db2 Database. See our Oracle Multitenant 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.
Hi Akin,
First, both DBs manage your relational data on several operating systems (Linux, Windows Server, ...) and as Cloud Services. The newer architecture of Oracle tries to support you in a mixed environment where you can distribute a large DB over your own servers and cloud services. But as we always saw in the past, if a new feature of Oracle is good, Microsoft will follow.
So your main questions should be:
-How big is your DB? The bigger, the more I suggest Oracle.
-Are you in a mixed world (Cloud and your own servers)? If Cloud is Azure, I think SQL Server is a good choice.
-Is the price a topic? The liscence rules of Oracle are sometimes complicated.
Hope this helps a little.
Hi Martin, it is no marketing rumor.
Oracle is the number one in terms of big databases and scalability. But as I wrote, Microsoft is always one step behind.
So if the price is no question and you need the best on the market, Oracle is the choice. But to use the full power, you need someone who knows how to plan and set up the whole environment!
The planning starts with a look at your amount of data, the decision of what response time is necessary, what is the yearly increase of the data,...
I worked on a project with several million transactions a day and we tested Oracle and Microsoft with this result: Oracle was the better. But we must use a lot of tuning features of Oracle and optimize the hardware environment for this task. Shortly, Oracle has a lot of 'screws' to tune, but if you don't know exactly what to turn on, it will fail.
But it is similar to SQL Server. Additional hardware is often not the solution.
Hi Akin,
Without going into the technical details; did you have a look a the pricing of MSSQL and Oracle databases?
I always hear that the Oracle database is better than MS SQL. But I never got to test this myself.
What I do know is that when I tell a customer the Oracle pricing, they are usually going in another direction.
You must have a very good functional reason to go for Oracle considering the price difference. As @Patric Gehl suggested: a very big database is good but for a good reason.
Kind regards,
Martin Zwarthoed