RE: DBAs:Databases 1:10 (Oracle) 1:31 (SQL Server)
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 13 Jun 2006 12:04:42 -0000
And yes, there is one more thing to consider:
In terms of functionality twice as big "Average number of users per database"
for Oracle than for MS is a big thing.
Let's say, online shop may provide web support for 50.000 customers instead of
25.000.
But in terms of DBA cost scaling from 25.000 to 50.000 is much more than just
adding 100% more of hardware.
Every next 1% of users may increase the cost exponentially...
But every next 1% of users may decide company's position in the market...
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Tony Jambu
Sent: 13. júní 2006 11:08
To: Oracle-L@xxxxxxxxxxxxx
Subject: DBAs:Databases 1:10 (Oracle) 1:31 (SQL Server)
Hi all
Recently, I came across an 'interesting' paper on the comparative difference of
the total cost of database administration between
Oracle and SQL Server. It was conducted by Alinean.
Some interesting findings:
Measure Microsoft Oracle
--------------------------------------- --------- ------
Average number of databases per company 107 87
Average number of users per database 328 716
Mission critical databases 66.1% 63.8%
Transaction-based databases 55.7% 60.3%
Decision-support databases 44.3% 39.7%
*** Databases supported per DBA 31.2 9.9
Users supported per DBA 6,784 5,567
Annual TCA per database $2,847 $10,206
Annual TCA per database user $13.09 $18.15
If you cant read the above, make sure you have it as fixed font or goto
http://www.alinean.com/PDFs/Alinean-MicrosoftAndOracleTCAStudy.pdf
I find it hard to believe that the average Oracle DBA can manage only 10
databases.
From memory, a past survey on best practices indicated that an Oracle DBA
manages on average about 30 Oracle databases.
I guess for my own interest and possibly all those interested too, we could
work out what our ratio of DBAs:Databases. If you are so kind as to reply to
the following questions.
Q1. How many DBAs are in your company
Q2. How many Production Databases (Oracle + others) do they manage Q2. How
many Test/Dev Databases (Oracle + others) do they manage
If you do not wish to publish the figures directly to this list, just send me
an email and I will collate it after a week.
tony
--
//www.freelists.org/webpage/oracle-l
Fyrirvari/Disclaimer
http://www.landsbanki.is/disclaimer
--
//www.freelists.org/webpage/oracle-l
Fyrirvari/Disclaimer
http://www.landsbanki.is/disclaimer
--
//www.freelists.org/webpage/oracle-l
Other related posts:
