Compare Oracle Multitenant vs. SQL Server
Use Oracle Multitenant? Share your opinion.
 | Anonymous User Domain architect at a financial services firm |
Find out what your peers are saying about Oracle Multitenant vs. SQL Server and other solutions. Updated: March 2021.
474,857 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:
"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"
"Maintaining databases is a valuable feature for us."
"The feature that I like on Multitenant is the ease - it is very easy for my team to run the database."
"The most valuable feature is replication because we had several replicas of the SQL Server database in different geographical locations."
"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."
Cons
"The user interface for this solution can be made better."
"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."
"It would be beneficial to include this solution with Oracle Enterprise, but Oracle charges additional fees for it."
"This solution is a bit complicated when collecting from containers - that feature should be a bit better."
"I would like to have more replication scenarios."
"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."
"This solution is a little bit pricey."
"For me, I will go with it if I have the budget. Some features are nicer than before, but at the end of the day, you always have a limited budget. I prefer to upgrade and get a specific hardware when possible. At the end, you will have to make a compromise. You will not get everything you would have liked to have."
"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."
Use our free recommendation engine to learn which Relational Databases solutions are best for your needs.
474,857 professionals have used our research since 2012.
Ask a question
Earn 20 points
Top Answer: It is a very user-friendly solution. It is easy to manage the databases and troubleshoot any issue. It is a perfect solution for the volume or transactions that we need to manage.
Top Answer: SQL pricing is slightly high compared to where it was before. That said, compared to other products like Oracle, they are still cheap. It's not overly expensive in comparison to others. The final… more »
Top Answer: The way to make cursors and manage raw data in rows can be improved. Currently, the way to construct or build these cursors is very hard, and you can waste memory. You need a highly skilled person to… more »
Views
1,768
Comparisons
993
Reviews
4
Average Words per Review
373
Rating
8.5
Views
23,153
Comparisons
18,525
Reviews
43
Average Words per Review
533
Rating
8.3
Compared 20% of the time.
Compared 18% of the time.
Compared 9% of the time.
Compared 7% of the time.
Compared 6% of the time.
Compared 16% of the time.
Compared 12% of the time.
Compared 9% of the time.
Compared 9% of the time.
Compared 8% of the time.
Oracle Pluggable Database
Microsoft SQL Server, MSSQL, MS SQL
Oracle Multitenant - an Oracle Database 12c Enterprise Edition option – introduces a new architecture that enables customers to easily consolidate multiple databases, without changing their applications. This new architecture delivers all the benefits of managing many databases as one, yet retains the isolation and resource prioritization of separate databases. In addition, Oracle Multitenant enables rapid provisioning and upgrades, and fully complements other options including Oracle Real Application Clusters and Active Data Guard. p>
For more information on Oracle Multitenant, 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.
Learn more about Oracle Multitenant
Learn more about SQL Server
An Post, National Oilwell Varco, SAS Institute, Sportmaster, Y-Telecom
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.
Computer Software Company37%
Comms Service Provider23%
Government6%
Financial Services Firm6%
Financial Services Firm15%
Computer Software Company13%
Manufacturing Company10%
Transportation Company7%
Computer Software Company26%
Comms Service Provider20%
Financial Services Firm7%
Media Company6%
Small Business50%
Midsize Enterprise20%
Large Enterprise30%
Small Business38%
Midsize Enterprise23%
Large Enterprise39%
Find out what your peers are saying about Oracle Multitenant vs. SQL Server and other solutions. Updated: March 2021.
474,857 professionals have used our research since 2012.
Oracle Multitenant is ranked 15th in Relational Databases with 4 reviews while SQL Server is ranked 1st in Relational Databases with 50 reviews. Oracle Multitenant is rated 8.6, while SQL Server is rated 8.4. The top reviewer of Oracle Multitenant writes "Enables you to stop and start each application without impacting others". 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 Multitenant is most compared with MariaDB, IBM Db2 Database, SAP HANA, CockroachDB and IBM Informix, whereas SQL Server is most compared with SAP HANA, Oracle Database, IBM Db2 Database, Teradata and MariaDB. See our Oracle Multitenant 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.