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 |
|
sql777
Constraint Violating Yak Guru
314 Posts |
 Posted - 2008-05-07 : 09:46:28
|
| Hi,You know how there are lots of hosted applications out there, many of them provide you with your own database (not shared).1. If a server has 1K databases on it, will this slow down the server just due to the # of databases? (each user has their own database, but they won't be accessing it that much really).A seperate database is required for security purposes usually.2. Can you still open up EM with 1K+ databases? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-05-07 : 09:48:58
|
| 1. It will slow the start up of the server generally as SQL will need to check each database for integrity and depending on your maintenence plans and access levels, it is possible that you will see a slowdown.2. I don't see why not. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-07 : 10:54:57
|
| How high is the transaction rate? Might have memory issues. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-07 : 15:36:14
|
| True, sql needs memory for every opened db. |
|
|
|
|
|
|
Does sql server slow down if it has lots of db's?