Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
44443
Starting Member
10 Posts |
 Posted - 2005-06-30 : 10:14:50
|
| Guys, I have question regarding no of Databases we can have per server group.I am concerned that if I have more no of databases per server group that there would be a problem with the resources allocation like (memory) and performance of the databasesCan you guys suggest me or direct me to any resources which says I should have more than 'N' no of databases per server group.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-06-30 : 16:33:03
|
| What do you mean by server group? Are you referring to Enterprise Manager?Tara |
 |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2005-07-01 : 13:04:32
|
| According to the topic "Maximum Capacity Specifications" in BOL, there is a hard limit of 32,767 databases per instance of SQL Server. How close you can get to that, and still have happy users, will depend on your hardware. I have one server with around 50 databases that is perfectly content with its load, if that helps. I am sure that pales in comparisson to some of the other folks around here. |
|
|
|
|
|
|
Databases per Server Group