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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-18 : 11:59:24
|
| dips writes "Hi,Can you have multiple databases on same sql server instance and how does it affect the performance aspect of sql server. What are the pros and cons of doing this." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-07-18 : 12:04:26
|
| Oh yeah, you can have hundreds, even thousands of databases on a single SQL Server. The only limitations depend on how much disk space you have and how powerful the server is. Other performance considerations depend on how you design the databases, what kind of disk system you have, and how many users access the server. We'll need more details about your setup before we can answer any other questions though. |
 |
|
|
|
|
|
Multiple Databases