I've read some docs from Forrester on this & they claim that their
larger customers seem to converge on a 24:1 database:DBA ratio. You can
go to their web site & register to get some free docs that provide some
details on this.
Mark
-----Original Message-----
From: Bellizzi Christopher - IBG
[mailto:mssqldba-ezmlmshield-x44491107.[Email address protected]
Sent: Wednesday, March 29, 2006 8:22 AM
To: LazyDBA Discussion
Subject: RE: Best Practices
How many DBA's are needed to screw in a light bulb?
None thats a hardware issue.
I know its an old one.
cjb-
http://searchoracle.techtarget.com/tip/1,289483,sid41_gci1059266,00.html
?FromTaxonomy=/pr/294531
ORACLE DATABASE ADMINISTRATOR
How many DBAs?
Craig Mullins
One of the common problems that perplexes DBA groups is how many DBAs
are needed to support their environment. One thing is for sure: It is
always more than are currently there (from the DBA's point of view), but
the management perspective is usually that there are just enough (or
even worse, too many already).
Staffing the DBA organization is not a simple matter. There are several
non-trivial considerations that must be addressed including the size of
the DBA staff and the reporting structure for the DBAs. In my book,
Database Administration: The Complete Guide to Practices and Procedures,
I discuss the issues that impact DBA staffing levels.
Basically, it boils down to complexity. The more complex your
environment, the more DBAs you will need to assure availability, ensure
data integrity, optimize performance and basically keep your database
systems and applications operational. Of course, it is very difficult to
combine all of the mitigating factors into a specific formula that will
dictate the optimum number of DBAs to employ.
Some industry analysts have tried. A few years ago analysts at META
Group published a loose formula for calculating DBA level of effort.
Their formula applied weights to six factors: system complexity,
application immaturity, end-user sophistication, software functionality,
system availability and staff sophistication. By measuring each of these
items as much as possible to indicate high or low rates, you can plug in
values to the formula and arrive at a a number that is tranlated into an
estimate for the number of DBAs required. Of course, this research is
dated and META Group has since been acquired by Gartner Group.
I've heard of DBA groups who use a simple formula like 1 DBA per 10
database instances. But how useful is that, really? A very experienced
DBA could easily handle double that if the activity is low and the
systems are well tuned. But if activity is high, the databases are not
well designed or SQL is coded inefficiently, that DBA might be stretched
to his (or her) limits. You just can't put a simple formula on top of a
complex problem.
-----Original Message-----
From: Michael Everett
[mailto:mssqldba-ezmlmshield-x79434781.[Email address protected]
Sent: Tuesday, March 28, 2006 3:42 PM
To: LazyDBA Discussion
Subject: RE: Best Practices
So management says. Reality is of a different approach...
I read an article at one time awhile ago that mentioned a ratio of 12:1
on "average" databases and 6:1 on mission critical databases. I don't
have the article anymore and can't seem to locate where I got it from.
We currently have 3 DBA's that manage 65 production SQL servers and 14
test. Not counting MSDE.
Not complaing, job security. Was just looking for any documentation to
support this.
Thanks
>>> "Edwards Ed " <mssqldba-ezmlmshield-x11950471.[Email address
protected] 3/28/2006 2:29:34 PM >>>
Michael,
A SQL Server DBA can manage all SQL Server databases. He or she
doesn't need any help! HEHE!
Please take a few minutes to provide feedback on the quality of service
you received. The Department of Education values your feedback as a
customer. Commissioner John L. Winn is committed to continuously
assessing and improving the level and quality of services provided to
you by Department staff. Simply use the link below. Thank you in
advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Michael Everett
[mailto:mssqldba-ezmlmshield-x78443700.[Email address protected]
Sent: Tuesday, March 28, 2006 3:00 PM
To: LazyDBA Discussion
Subject: Best Practices
Hello everyone,
Can someone point me in the right direction? I am looking for
documentation that sets "guidelines" for the ratio of SQL DB servers to
DBA. We are trying to justify the need for an additional DBA in our
company.
Thank you all in advance.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
************************************
This e-mail and any files transmitted with it are proprietary and
intended solely for the use of the individual or entity to whom they are
addressed. If you have received this e-mail in error please notify the
sender. Please note that any views or opinions presented in this e-mail
are solely those of the author and do not necessarily represent those of
ITT Industries, Inc. The recipient should check this e-mail and any
attachments for the presence of viruses. ITT Industries accepts no
liability for any damage caused by any virus transmitted by this e-mail.
************************************
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
------------
This communication is intended for the use of the addressee only and may contain information that is privileged or confidential. If you are not the addressee, you are hereby notified that any dissemination, distribution or use of this communication is prohibited. If you received this communication in error, please destroy it, all copies and any attachments and notify the sender as soon as possible. Any comments, statements or opinions expressed in this communication do not necessarily reflect those of H.J. Heinz Company, its subsidiaries and affiliates.
MS Sql Server LazyDBA home page