up vote 0 down vote favorite
share [g+] share [fb]

I heard that in general, you don't see a single server running sqlserver having more than 100-150 databases on it.

Is this the same case with mysql or postgres?

link|improve this question
26% accept rate
2  
Sooner or later you'll hear people say just about anything. Don't mean it's true though. – John Gardeniers Dec 23 '09 at 2:43
feedback

2 Answers

up vote 4 down vote

number of databases is an irrelevant measure. It's more to do with the number of user connections, the query load & the size of the database.

According to this SQL Server can have 32,767 databases attached to it. You probably won't see this in production, but it is possible!

link|improve this answer
Indeed, I have seen shared hosting with 1,000+ SQL Server databases hum along without any problems and others with only a few that were "overloaded" because of intense query volumes and lots of computed columns. It all depends on what those databases are doing and what the load is like, – Justin Scott Dec 23 '09 at 3:03
feedback
up vote 0 down vote

The most I've ever seen on sql server instance was 3500 databases, just shy of a petabyte total data. It was interesting to see a windows sql cluster with a dedicated SAN. On a side note there was also an analysis services cluster with it's own dedicated san as well. I have no idea how many cubes were on that instance.

As I rarely deal with mysql (I've only done migrations from mysql to sql server) and have never dealt with postgres I can't comment on scalability of those platforms. The biggest mysql server I've seen was 10 DBs with about 4 terabytes of data total.

link|improve this answer
ok so it was 1 instance, but spread accross many servers? I wonder how sql manager handles 3500 databases, can you even open sql manager with that many db's? – user2659 Dec 23 '09 at 12:48
You can certainly open sql manager. I suspect that performance was not a concern as this institution company was very database intensive. – Jim B Dec 23 '09 at 15:00
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.