question

Patrick Curry avatar image
Patrick Curry asked

What is the greatest ratio - DBA to SQL Instances **OR ** Databases?

How many databases and servers do you support? It certainly is not the full measure of a DBA, but I've just been wondering.

databasedbaserver-instances
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image Fatherjack ♦♦ commented ·
as this isnt a technical question might it be worth considering it to be a community wiki question rather than a points earning one ??
0 Likes 0 ·
Patrick Curry avatar image Patrick Curry commented ·
That sounds fine.
0 Likes 0 ·

5 Answers

·
Patrick Curry avatar image
Patrick Curry answered

I lead a small team that supports over 2300 SQL instances and 15,700 user-defined databases.

2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

DaniSQL avatar image DaniSQL commented ·
Can you break it down in versions? How many of all these is 2000, 2005, 2008 and 2008 R2?
0 Likes 0 ·
Patrick Curry avatar image Patrick Curry commented ·
Sure: - 2,338 SQL 2000 (migrating and upgrading this year) - 3 SQL 2005
0 Likes 0 ·
Grant Fritchey avatar image
Grant Fritchey answered

Our production team handles about 300 instances and consists of 2 DBA's. But, they get help from our database development team. There are six of us.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

DaniSQL avatar image
DaniSQL answered

I am the only DBA and I support around 40 Instances and 550 databases.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image
Fatherjack answered

I'm a bit ashamed to admit that I only manage approx 30 instances with a hundred or so databases. I feel so inadequate ... !
Thinking about it though I also do application dev, project management, system analysis and what not too.

1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Patrick Curry avatar image Patrick Curry commented ·
:-) Don't be, numbers aren't everything. You do the best job with what's been entrusted to you.
0 Likes 0 ·
ThomasRushton avatar image
ThomasRushton answered

I'm one of a team of two supporting 36 or so servers with only a couple of hundred client databases.

I do do other stuff, though - for example, I've spent some time just hacking together excel spreadsheets to run various BusinessObjects reports much much quicker than BO can manage. The next job on the list is way off-beam for a DBA - setting up Wordpress!

2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image Fatherjack ♦♦ commented ·
all good variety and experience. Sounds like a fun place to work!
0 Likes 0 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
Oh, it's all good, and highly enjoyable.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.