The Total Cost of Administration Champ: Microsoft SQL Server 2005 or Oracle Database 10g?
Computerworld - As platforms continue to evolve in the technology industry, a central concern for IT executives is implementing the right systems to maximize the return on each investment. Since labor costs and equivalent outsourced services dominate most IT budgets — over 56% of IT spending on average — selecting platforms with lower implementation and ongoing management costs can significantly improve overall IT efficiency. More important, since innovation is only 10% of the typical IT budget today, reducing ongoing management costs can help you reallocate precious resources and budgets to more innovative tasks and projects — delivering true business value.
One of the most important infrastructure investments is a database platform. Two of the leading choices are Microsoft SQL 2005 and Oracle Database 10g. So, for those seeking to reduce overall costs and reallocate labor investments to more innovative tasks, the obvious question is, "Which has the lower total cost of administration (TCA)?"
To determine the comparative TCA of these platforms, Alinean Inc. conducted independent, in-depth interviews with 100 directors of database administration and senior-level database administrators regarding their database environments, user populations and database administration activities. The results of the survey can be found online (download PDF).
The results revealed that, overall, Microsoft SQL Server 2005 required significantly less effort to install and maintain than Oracle Database 10g. Study participants reported that on average a database administrator could manage more than 30 Microsoft SQL Server 2005 databases, while Oracle 10g implementations required one DBA per 10 databases. On average, the annual cost for administration is $2,847 per year per database for Microsoft SQL Server 2005 and $10,206 per year per database for Oracle 10g. That's a savings of more than 350% in annual costs per database for the Microsoft platform.
But was the study revealing a true difference in administrative costs, or just differences that could be attributed to smaller or less mission-critical Microsoft SQL Server 2005 installations? To ensure similar comparisons, the study examined potential differences in the application, load and complexity of the database instances. As expected, the Oracle databases supported more users per database (2 to 1) and larger volume size (3.6 to 1) than the Microsoft databases on average. So it makes perfect sense that Oracle would be more expensive to manage on a per-database basis, but the costs were still slightly higher for Oracle than expected in comparison.
Comparing costs per user supported, we found that Microsoft SQL Server 2005 still has a TCA advantage on a per-user basis, $13.09 per user versus $18.05 per user for Oracle. However, when large-volume databases were examined, Oracle 10g had the lower TCA: $46.76 per gigabyte for Oracle 10g versus $66.58 for Microsoft SQL Server 2005.
Comparing the importance of the database environments, participants reported similar levels of business reliance on the two database platforms, which is somewhat surprising, given the greater size and user populations for the Oracle databases. Even though the majority of Oracle 10g installations were geared more toward transaction-based databases than decision-support databases, Microsoft SQL Server 2005 actually had a slight edge in the percentage of databases classified as mission-critical.
- Silicon Valley's 19 Coolest Places to Work
- Is Windows 8 Development Worth the Trouble?
- 8 Books Every IT Leader Should Read This Year
- 10 Hot Hadoop Startups to Watch
- Slideshow: 7 security mistakes people make with their mobile device
- iOS vs. Android: Which is more secure?
- 11 sure signs you've been hacked
- Windows® XP Migration: Protect and Secure Critical Data With the end of the Microsoft Windows XP operating system's lifecycle on April 8, 2014, businesses are faced with the decision to migrate...
- Exponentially Accelerate Data Protection and Recovery with Simpana 10 IntelliSnap® Snapshot Management Technology Are you making the best use of your storage array snapshot functionality? CommVault Simpana 10 IntelliSnap technology manages hardware-based snapshots across multiple vendor...
- Meeting Changing Information Management Needs with Next-Generation Email Archiving Learn more about the ever-changing landscape of next-generation email archiving and gain insight about information management needs in this Info-Tech whitepaper.
- CIOs Deliver Productivity Breakthroughs with Intelligent Digital Signage Retailers have long recognized the influence that digital signage provides over a shopper's point-of-purchase decision making process.
- Top 4 Digital Signage Fails Join RMG Networks for a look at four of the most common reasons digital signage fails in corporate businesses. Learn about strategies to...
- Increasing the Value of Your Reports and Dashboards Learn how incorporating other analytical capabilities such as predictive modeling and visualization can increase the value of your reports and dashboards by providing... All Management White Papers | Webcasts