System News
Oracle Database 11g vs. Microsoft SQL Server 2008
An Edison Group Comparative Management Costs Study
April 2, 2010,
Volume 145, Issue 5

The study demonstrates not only that DBAs can perform routine administrative functions more quickly with Oracle, but that these functions are quantifiably easier to perform.

-- The Edison Group
 

An Edison Group report offers a comparative management costs study, revealing how the Oracle Database widens the manageability lead over Microsoft SQL Server 2008.

The study results show that the Oracle Database 11g holds a substantial advantage over Microsoft SQL Server 2008. In the Edison Group's detailed analysis, results reveal:

  • DBAs can perform typical administrative functions in 41 percent less time when using Oracle Database 11g compared to Microsoft SQL Server 2008.

  • Oracle Database 11g requires 43 percent fewer steps for the same set of standard RDBMS tasks than Microsoft SQL Server 2008 using Edison’s metric for complexity assessment.

  • Benefiting from increased DBA productivity due to lower complexity and higher efficiency cited above, businesses could save up to $33,520.47 per year per DBA by using Oracle Database 11g rather than Microsoft SQL Server 2008.

The main areas of difference between the two products identified in the report were:

  • Backup & Recovery: In the case of backup and recovery tasks, Oracle Database 11g offers architectural and functional capabilities beyond those offered by SQL Server 2008. Oracle Database 11g took 53 percent less time and 60 percent fewer steps than Microsoft SQL Server in backup and recovery tasks.

  • Performance Diagnostics and Tuning: In this category, Oracle Database 11g demonstrated a significant 87 percent savings in time.

Analysts with Edison Group acknowledge that there are a number of ways to interpret the significance of the savings stated above, depending upon a variety of factors. Organizations need to consider its size as well as the relative importance of higher productivity and the need for superior performance for specific tasks and classes of tasks.

"What is clear is that both Microsoft and Oracle have provided their customers with efficient tools for management of their respective database systems," the report states. "But when the cost of operations is analyzed, Oracle Database 11g can provide organizations with 41 percent annual DBA-related cost savings over Microsoft SQL Server 2008."

Readers interested in reading more about these finding will find the 85-page report explains the criteria used in the study, including how researchers weighted and calculated the results and a description of the workloads evaluated. It also presents the results of each set of tests, providing summary findings and a discussion of their relevance to business operations. The Appendices provide details on the test platform, clarification of architectural and terminology issues, the detailed test results, a discussion of the Edison Group's Complexity Calculation Formula, a detailed list of the actual steps performed and their individual timings, and a glossary of task areas.

This report is one in a series of Comparative Management Cost Studies (CMCS) comparing Oracle Database with database management systems offered by other leading enterprise software vendors. Another report on Oracle Database 11g vs. IBM DB2 Enterprise 9.5 is available for review.

More Information

Comparative Management Costs Study: Oracle Database 11g vs. Microsoft SQL Server 2008

Oracle Database 11g vs. IBM DB2 Enterprise 9.5 - another Edison Group report

Oracle Database

Read More ... [...read more...]

Keywords:

fullsource
 

Other articles in the Oracle section of Volume 145, Issue 5:
  • Oracle Database 11g vs. Microsoft SQL Server 2008 (this article)

See all archived articles in the Oracle section.

Popular Articles in
Vol 197, Issue 3
Popular IT Articles





Popular Articles in
Vol 197, Issue 3
Popular IT Articles


News and Solutions for Users of Solaris, Java and Oracle's Sun hardware products
Just the news you need, none of what you don't – 42,000+ Members – 24,000+ Articles Published since 1998