Yes, I understand there are so many variables, considering that one database can be left alone for years perhaps thanks to proper maintenance built-in by the developers or the vendor, whereas another can require constant care - but my question to the DBA Community out there, do you have any calculations used or hard-fast rules regarding the number of Database Users per DBA or Number of Servers per DBA to manage without high downtime risk?
Here are the answers and comments I received on the SQL Server Central version of this Blog
Posted by evangeld77 on 7 September 2011
There are many white papers seeking to prove which database platform is less expensive to own. Regardless of their conclusion, they seem to use an estimate of 10 - 15 minutes per database, per day. That translates to around 32 databases for a full time DBA.
Rationalize that number with the ratios of production databases to test and development, etc.
I hope that helps. I'm open to other ideas.
Posted by dooncomputer on 5 October 2011
• Average is 40 databases / DBA
• Lowest is 8 databases / DBA (Large Organization)
• Highest ratio is 275 databases / DBA
Anyone else has any comment/suggestion?
Posted by dooncomputer on 5 October 2011
Posted by Hugo Shebbeare on 19 October 2011
Currently, I am responsible for about 350 user databases at around 5TB (when behaving and under control).
Thankfully there are three monitoring systems (SCOM, Spotlight, SQLResponse) to help out and a couple of other cross-trained Oracle/MySQL DBAs that can take the spill over, otherwise the scary FTE DBA/database ratio would be unmanageable.
I feel lucky considering that I had a friend who was put in front of 225 instances once, but he did not stay long in that organisation due to the stress of putting our fires constantly.
Posted by DBSlave on 28 November 2011
Posted by Hugo Shebbeare on 11 December 2011