Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

How many Databases are you managing Expand / Collapse
Author
Message
Posted Thursday, April 3, 2014 12:15 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 9, 2014 8:38 PM
Points: 16, Visits: 19
Hello DBA's

just wondering who is managing maximum number of Databases?

PLEASE REPLY

Thank You
Post #1558151
Posted Thursday, April 3, 2014 12:23 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 4:59 PM
Points: 23,000, Visits: 31,482
Why?


Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1558160
Posted Thursday, April 3, 2014 12:37 PM This worked for the OP Answer marked as solution
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 2:38 PM
Points: 423, Visits: 1,315
Number of databases does not matter. At my last place I had just one database with size > 2.5 TB. At my present place I have about 20-30 databases , but the largest is less than 300 GB. Their combined size is 6 TB +. And you always can consolidate/split databases.

What I think does matter is combined size of all db's and number of production servers.
Post #1558170
Posted Thursday, April 3, 2014 12:46 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 9, 2014 8:38 PM
Points: 16, Visits: 19
Thank You i am accidental DBA trying to understand how many Databases a DBA manages normally...
Post #1558177
Posted Thursday, April 3, 2014 1:09 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:31 AM
Points: 21,209, Visits: 14,891
FWIW, I managed 4500 servers at a previous job with over 10,000 databases.

I recently managed over 200 servers for various clients with total DB size over 50TB.

It all kind of depends on what is needed at the moment as to how many databases and database size that I manage.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1558199
Posted Thursday, April 3, 2014 2:41 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 18, 2014 9:25 AM
Points: 32, Visits: 539
How about 190 DB Servers, 218 SQL Instances, 3869 Databases and 57.9 TB of DB Storage (Today).
Post #1558258
Posted Thursday, April 3, 2014 3:48 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 7:18 AM
Points: 1,885, Visits: 18,484
jrp12 (4/3/2014)
Hello DBA's

just wondering who is managing maximum number of Databases?

PLEASE REPLY

Thank You


what is your definition of "managing".....??


__________________________________________________________________
you can lead a user to data....but you cannot make them think !
__________________________________________________________________
Post #1558281
Posted Thursday, April 3, 2014 6:00 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 7:04 AM
Points: 325, Visits: 3,194
My 70+ severs and 800+ databases doesn't seem as bad now, even if it is only me, some servers over 15 years old and I still don't believe I know about all of them (in my defence, pulling together an estate built up totally randomly over 15 years before I got there with no SQL Server DBA).

I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
Post #1558324
Posted Thursday, April 3, 2014 8:40 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, July 14, 2014 2:06 PM
Points: 3,860, Visits: 7,130
I manage 21 servers with about 12 DB's per server, total size is about 11TB (with 2 servers accounting for 9TB of that total amount)

Good Lord Jason HOW ON EARTH DID YOU MANAGE TO DO THAT???


______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1558343
Posted Friday, April 4, 2014 3:54 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
It purely depends on the customer requirement. We can't create more database and put more data to manage. Instead of finding howmany DB supports try to understand environment of the customer and how you can handel it; will help more.

It depends on many factors like:
Monitoring tool
howmuch automation
load on the server
criticality of the database
availability of the database

HTH


---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1558414
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse