RE: Best Practices

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





MS Sql Server LazyDBA home page