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 |
|
the1gadget
Yak Posting Veteran
55 Posts |
 Posted - 2008-10-20 : 04:49:07
|
| Hi AllJust started at a new job, and something that they do here strikes me as odd.For each new database they install a new express instance, instead of using one instance with many databases. At the moment there is one server (OK it is a dev server) with 10 instances on it.Is this the right way to do things?-- David |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-10-20 : 05:26:17
|
| No |
 |
|
|
the1gadget
Yak Posting Veteran
55 Posts |
Posted - 2008-10-20 : 06:17:35
|
quote:
Originally posted by afrika
No
Well I guessed that  Any links or info to back it up.I want to stop this practice and I woulds like some evidence to show why.-- David |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-10-20 : 07:31:38
|
| Thats what databases are you. One instance, multiple databases.Each instance requires, memory, processing power, disk space etc And express versions are limited to 4gb of memory and many other limitations.I have never ever heard of such. |
|
|
|
|
|
|
Multiple Instances