RE: databases per dba
- From: "Khemmanivanh, Somckit" <somckit.khemmanivanh@xxxxxxxxxxxxxxxx>
- To: <DMcGibbon@xxxxxxxxxxxx>, "Oracle List" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 9 Jun 2005 14:37:02 -0700
Just curious, for those that have so many DBs per DBA -- how to you
effectively support them all in 1 day? Automation is going to help but
there are still issues that arise...i.e. performance issues, bugs, bad
change mgmt practices, users just being users, etc...=20
Thanks!=20
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dougie McGibbon
Sent: Thursday, June 09, 2005 1:10 PM
To: Oracle List
Subject: RE: databases per dba
My current count is over 70 database servers with a total of over 210
databases scatterred among them (this includes MS SQL Server, Oracle,
Sybase, Foxpro, PostrgreSQL, MySQL and DB2)
Number of DBAs ... 1
-----Original Message-----
From: z b [mailto:zimsbait@xxxxxxxxx]=20
Sent: Friday, June 10, 2005 5:57 AM
To: Oracle List
Subject: databases per dba
**************************
DISCLAIMER:=3D20
I would be willing to bet this type of question is poorly regarded in
this group, so
I apologize in advance for any distress it brings. ;-)=3D20
Also, since this may be frowned upon, please respond directly to this
email rather than the list to cut down list clutter.
**************************
Group,
Please read the disclaimer above before proceeding.
My team has been asked to gather averages of databases dba's manage.
We have looked at Garter and the like, and have some reasonable
numbers to present to the bean counters.
We have several hundred db's in house. Some are pre-packaged (People
Soft, Ora Apps etc) and most are home grown apps and support db's. We
support dev, qc (some systems have multiple qc systems), customer test
db's and of course, production. Systems vary from small OLTP's to
Enterprise level DSS's. A single application has typically 6
environments and instances.
We used the Gartner approach which has you weight db's on homegrown vs
packaged and on the combination of complexity and volatility (this
also includes dba skill levels, growth patterns, schema changes, tools
available to exploit etc). I think there were some things were absent
from the formula (and no formula will be perfect when looking at this)
but it is a good "rough outline". Of course, to get true TCO, you need
to balance this per market rates and take other external factors into
consideration.
However, above and beyond this formula, we're also looking at
real-world situations and shops. All the dba's on the team have
related past job experiences (what we've seen in shops we've been at
in past lives). If anyone is interested, what we've come up with so
far is ~15 instances/dba as a typical threshold.
I wanted to just get some rough numbers on how many db's others
support. I'd appreciate any feedback.
Thanks in advance.
Z
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
