SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


The DBA Dilemma: How Many DBAs Does It Take to Manage an Infrastructure?


The DBA Dilemma: How Many DBAs Does It Take to Manage an Infrastructure?

Author
Message
Rodney Landrum
Rodney Landrum
Old Hand
Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)

Group: General Forum Members
Points: 301 Visits: 716
Comments posted to this topic are about the item The DBA Dilemma: How Many DBAs Does It Take to Manage an Infrastructure?
Elliott Whitlow
Elliott Whitlow
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10066 Visits: 5314
I think this depends greatly on the infrastructure you have in place. If you don't have a good infrstructure the number of servers that any single DBA can handle is greatly diminished. Just think about patching, how many servers can you patch at once manually? I can think of all kinds of monitoring that you might need.. But just off the of my head..

1. Services running, SQL and Agent.
2. Services active, SQL responds to logins, Agent is running jobs.
3. Errorlog is monitored for issues.

Any other thoughts?

CEWII
TravisDBA
TravisDBA
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: General Forum Members
Points: 1988 Visits: 3069
Elliott W (10/26/2009)
I think this depends greatly on the infrastructure you have in place. If you don't have a good infrstructure the number of servers that any single DBA can handle is greatly diminished. Just think about patching, how many servers can you patch at once manually? I can think of all kinds of monitoring that you might need.. But just off the of my head..

1. Services running, SQL and Agent.
2. Services active, SQL responds to logins, Agent is running jobs.
3. Errorlog is monitored for issues.

Any other thoughts?

CEWII


I agree, this does tend to depend in what shape your infrastructure is in to begin with. Automated morning reporting on nightly backup routine status, errorlog checking, failed jobs, blocked or blocking processes, phyical disk alerts, etc. goes along way here to extend this number of servers a DBA can easily handle, at least it does for me anyway. Also, now with the release of SQL 2008 the DBA now has at his disposal two new features known as CMS (Central Management Servers) and PBM (Policy Based Management) that allow the DBA to deal with and maintain multiple db servers as a collective unit or group. Instead of having to deal with each of them individually. But of course, you need to get all of this in place first, and that can take some time to do. Not to mention that you might have to put out some major fires beforehand and get your infrastructure under control even before implementing automation and central management. However, the nice thing about this needed front work though is once you got it setup and organized once, then you are golden. Your daily admiistrator life immediately starts to get better, trust me. Adding servers to this mix after that point is a piece of cake. It is definitely worth the effort IMHO. It just all depends on what shape your production db servers are in and this tends to varies widely from company to company in my past experience. Smile I have seen some DBA's that have not got the 10 db servers that they are reponsible for organized and automated, and they end up chasing their tails all day long never really getting much accomplished. Then I have seen other DBA's that got 50+ db servers nice and automated, centralized, and organized and manage them quite well, with plenty of time to spare....and not to mention what your boss will think come evaluation time...

"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"
SQL_EXPAT
SQL_EXPAT
SSC Veteran
SSC Veteran (246 reputation)SSC Veteran (246 reputation)SSC Veteran (246 reputation)SSC Veteran (246 reputation)SSC Veteran (246 reputation)SSC Veteran (246 reputation)SSC Veteran (246 reputation)SSC Veteran (246 reputation)

Group: General Forum Members
Points: 246 Visits: 383
I have a team of 4 DBAs - 2 SQL and 2 Oracle. We manage administer:

270 SQL Servers -dev, test, UAT and production
70 Oracle on Linux servers - dev, test, UAT and production

So, thats 135 servers/SQL DBA and 35/Oracle DBA.

The only we we can achieve this is by working 24x7 and not taking any sick days or vacation :-D.

But, seriously, we achieve this through standardising on builds, monitoring scripts and alerting. Most of our servers are exactly the same in configuration. When we perform tasks we always do it on server groups not individual servers. Strict change management also helps here.

We're helped to a degree by a seperate infrastructure team who builds the servers and a tier 1 support team who respond to alerts. Also, many of our servers are commodity, 'scale-out' servers so even the databases are exactly the same.

Oracle DBAs perform secondary support to SQL and Vice Versa.

Its pretty tough and we could do with a couple more DBAs but the budget aint there. Its the 'new normal' i.e. doing more with less.

In a previous post at a gaming company who solely used SQL Server the ratio was 10:1 - we had 10 DBAs and about 120 servers to manage. In hindsight this was overkill and I only realise now how much you can save by standardisng kit and unifying your processes instead of adding more and more DBAs.

thanks

SQL_EXPAT
WayneS
WayneS
SSCrazy Eights
SSCrazy Eights (9.8K reputation)SSCrazy Eights (9.8K reputation)SSCrazy Eights (9.8K reputation)SSCrazy Eights (9.8K reputation)SSCrazy Eights (9.8K reputation)SSCrazy Eights (9.8K reputation)SSCrazy Eights (9.8K reputation)SSCrazy Eights (9.8K reputation)

Group: General Forum Members
Points: 9825 Visits: 10569
I assume you're counting a server as an instance of sql server? Thus one physical computer might have several sql servers?

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings

SQL_EXPAT
SQL_EXPAT
SSC Veteran
SSC Veteran (246 reputation)SSC Veteran (246 reputation)SSC Veteran (246 reputation)SSC Veteran (246 reputation)SSC Veteran (246 reputation)SSC Veteran (246 reputation)SSC Veteran (246 reputation)SSC Veteran (246 reputation)

Group: General Forum Members
Points: 246 Visits: 383
In my post I'm referring to physical servers. We only ever install 1 instance of SQL Server per server. Oracle is a little different.

Another thing I must mention is that many of these servers are DR servers. All of our live servers are mirrored between sites either through using Database mirroring, log shipping or running LIVE/LIVE.

thanks

SQL_EXPAT
jjarupan
jjarupan
SSC-Enthusiastic
SSC-Enthusiastic (115 reputation)SSC-Enthusiastic (115 reputation)SSC-Enthusiastic (115 reputation)SSC-Enthusiastic (115 reputation)SSC-Enthusiastic (115 reputation)SSC-Enthusiastic (115 reputation)SSC-Enthusiastic (115 reputation)SSC-Enthusiastic (115 reputation)

Group: General Forum Members
Points: 115 Visits: 488
It is depending on the company.
My past experience was monitoring 40 servers by myself(in Healthcare Industry), now ~ 300 servers all over US (in Financial service) by only 2 DBAs but mainly all maintenance job monitors by myself the other is senior DBA ( mainly in Application).
For monitor ~300 servers, it is very easy by a script and let it pages us when it has the problem.
Big problem always comes from a disk problem, need to change server and pretty much we have all backup files and some database files to recover.
Backup, Update stats,DBCC, shrink the file, restart service etc, all done by jobs by the server itself or from monitoring server.
All can be done by set one computer as monitoring server.
All update can be done automatically by the network process.
IMHO, reply to the question, How many DBAs Does it take to manage infrastructure? It should be 0 (zero) in nearly future.
No need DBA for infrastructure in the future.
(Some Company still needs Database Developer for the future).
It is possible, let Network guy install server and SQL server. Monitoring Server can detect the new server, install all jobs automatically by itself.
Steve Jones
Steve Jones
SSC Guru
SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)

Group: Administrators
Points: 62434 Visits: 19102
We had a similar setup to AJs when I was at JD Edwards. Production instances, almost all 1 instance / physical server, were in the 200-300 range. Two DBAs.

We also helped support some development environments at times as well. We weren't slammed most of the time, but it was constant tinkering, monitoring, making sure that the stuff we'd set up to alert us ahead of time was working. And of course, something is always broken with 100s of instances.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Patrick Cahill
Patrick Cahill
Hall of Fame
Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)

Group: General Forum Members
Points: 3809 Visits: 994
We only have 8 sql servers and 2 dba's. We would be better off with only 1 dba and 1 database developer. I am a little bored with so little to maintain. I came from a shop with 50 sql servers with 2 dba's and 4 database developers, this was much better. Right now my biggest challenge is to stay busy and keep learning new stuff.
Elliott Whitlow
Elliott Whitlow
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10066 Visits: 5314
I read one person suggest having one server monitor them all, which in general is good, BUT, you still need to have something monitor the monitor server, at least a little bit.

I mean if you regularly get notified of things and then all of a sudden don't, you might not notice it for a while, even if the secondary monitoring is just are the services running and responding should be probably good enough..

I keep reading this in the posts..
Bad/poor/no infrastructure and change control = Lots of DBA bad days..

CEWII
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search