RE: databases per dba

From: Khemmanivanh, Somckit <somckit.khemmanivanh_at_weyerhaeuser.com>
Date: Thu, 9 Jun 2005 14:37:02 -0700
Message-ID: <65C0D8935651CB4D96E97CEFAC5A12B944460C@wafedixm10.corp.weyer.pri>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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_at_gmail.com]=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
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jun 09 2005 - 17:42:05 CDT