How many Databases are you managing

Question

Post reply

How many Databases are you managing

jrp12

Valued Member

Points: 61
More actions
April 3, 2014 at 12:15 pm

#291910

Hello DBA's
just wondering who is managing maximum number of Databases?
PLEASE REPLY
Thank You

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Lynn Pettis

SSC Guru

Points: 442467

April 3, 2014 at 12:23 pm

#1703014

Why?

SQL Guy 1 SSCoach Points: 15979 More actions · Answer 2

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.

jrp12 Valued Member Points: 61 More actions · Answer 3

Thank You i am accidental DBA trying to understand how many Databases a DBA manages normally...

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

DeWayne_McCallie Hall of Fame Points: 3617 More actions · Answer 5

How about 190 DB Servers, 218 SQL Instances, 3869 Databases and 57.9 TB of DB Storage (Today).

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 6

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
and remember....every day is a school day

andrew gothard SSChampion Points: 12314 More actions · Answer 7

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.

MyDoggieJessie SSC-Forever Points: 44486 More actions · Answer 8

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 :w00t: HOW ON EARTH DID YOU MANAGE TO DO THAT???

______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

free_mascot One Orange Chip Points: 27169 More actions · Answer 9

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."

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

MyDoggieJessie (4/3/2014)
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 :w00t: HOW ON EARTH DID YOU MANAGE TO DO THAT???

Let's just say, I don't think I would try it again :hehe:

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

tim_harkin SSCrazy Points: 2399 More actions · Answer 11

Continuing on a theme here, not all databases are equal, so comparing the number of managed databases is a faulty metric. Managing 100 databases that support (well developed) third party applications can be easier and less work than supporint two databases that support in-house applications that are constantly in flux.

jrp12 Valued Member Points: 61 More actions · Answer 12

Thank You all

it really helped me to understand how really people/DBA's are thinking.

I am learning SQL and working on MCTS 70-432 Exam and really could not understand what is work look like.

THANK YOU ALL

DKG-967908 SSCrazy Points: 2345 More actions · Answer 13

Dear Friend,

No of DBs, Servers and database size always depends on the environment you are working. There is no fix size of databases or servers.

One DBA can manage one server and 100s of servers too. Depending how stable your environment is and how you setup the monitoring into them (automatic or manual etc).

There are lots of replies above so your concern should be clear now.

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 14

I have found that managing databases and servers is pretty easy although I certainly prefer not to have to keep up with hunred or thosands like some of the folks on this thread.

What I have found is that the more users that are allowed to write their own queries and the more developers that are allowed to promote their own code, the more troublesome that particular database/server is going to be. If there's no QA and no code review process in place, you can generally multiply that problem by a factor of 10. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)