| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2002-10-23 : 09:59:44
|
| And if you're the person that chose 2,000 or more post some details. I'm curious.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
 |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2002-10-23 : 10:18:56
|
It wasn't me!!!  Interesting (and worhless) fact:The maximum number of databases on one SQL server box is 524272 (32767 db's * 16 instances)Edited by - andraax on 10/23/2002 10:19:17 |
|
|
|
monkeybite
Posting Yak Master
152 Posts |
Posted - 2002-10-23 : 10:24:35
|
| It wasn't me either, but i do have a story about 2000+ databases...Our office used to have our websites hosted externally at a service provider that will remain nameless . . . They offered free SQL 7 databases to their subscribers, but hosted all of the databases on the same server. There were well over 3,000 on that one machine. Forget about opening enterprise manager and trying to connect to that box, nobody had that kind of time to kill.Based on the professionalism that the service provider had shown to us, we're pretty sure that the owner was a 15-year old kid running everything out of his garage, and his mom wouldn't let him add more servers.-- monkey |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-10-23 : 10:29:11
|
| Unfortunately that level of professionalism and service is all to common in the web hosting world.Damian |
|
|
|
monkeybite
Posting Yak Master
152 Posts |
Posted - 2002-10-23 : 10:34:39
|
quote:
Unfortunately that level of professionalism and service is all to common in the web hosting world.
Let's expand that thought to encompass a good majority of the business world. -- monkey |
|
|
|
sanjnep
Posting Yak Master
191 Posts |
Posted - 2002-10-27 : 03:19:36
|
| Oh what a intresting question.I really like it.Pls keep it on."Heaven's light is our guide"Sanjeevshrestha |
|
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-11-01 : 12:19:45
|
| We've got 2000 or more here (i think the count is 2300). All have various uses I guess... Different projects, different stages of projects (dev,test,acceptance,production.. actually, most production dbs are on their own server), backups and others. It's kind of a giant development and testing box that got outa hand I think. I'm just here to write a few stored procs and dts packages for them... I don't even try to understand half the practices here.-----------------------SQL isn't just a hobby, It's an addiction |
|
|
|
|
Poll: Largest number of User databases on one server?