AW: DBAs:Databases 1:10 (Oracle) 1:31 (SQL Server)
- From: <F.Castillo@xxxxxxxxxxxxx>
- To: <tjambu_freelists@xxxxxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
- Date: Tue, 13 Jun 2006 13:22:58 +0200
Hi,
How do they compare MS to Oracle
In Oracle term a database would be what a MS/Sybase call a "SQL Server". They
have lots of databases - a thing that compares to a combination of
schema/tablespace, if I'm not completely wrong.
So what does Alinea _exactly_ mean by the term 'database'?
Felix
PS: I've actually not the time to read the hole n-page paper :-(
-----Ursprüngliche Nachricht-----
Von: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] Im
Auftrag von Tony Jambu
Gesendet: Dienstag, 13. Juni 2006 13:08
An: Oracle-L@xxxxxxxxxxxxx
Betreff: 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » AW: DBAs:Databases 1:10 (Oracle) 1:31 (SQL Server)
