RE: DBAs:Databases 1:10 (Oracle) 1:31 (SQL Server)
- From: "Laimutis Nedzinskas" <Laimutis.Nedzinskas@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 13 Jun 2006 11:48:30 -0000
well, it seems that the term "database" in this report is more or less adequate.
Calculating by user numbers is quite a new idea in measuring database load but
let it be so.
There is another fact that can be drawn from the report:
Average number of users per company is:
35,096(MS) vs 62,292(Oracle)
Which probably means 2 times bigger company, more users, higher cost of
failure.
In that light "Annual TCA per database user $13.09(MS) vs $18.15(Oracle)" does
not seems so bad.
-----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
Other related posts:
