Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
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

2 Answers 2

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!

share|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

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.

share|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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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