|
Home > Archive > MS SQL Server > July 2005 > Necessity.....
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Branden Smith 2005-07-14, 8:23 pm |
| Installing multiple instances of SQL Server is really good.
Some one can tell me when exactly those situations arises.
SQL 2K.
Thanks,
Smith
| |
| ChrisR 2005-07-14, 8:23 pm |
| I have 6 production environments. I have two test boxes, each with 3
instances of SQL. Same with staging. Just too costly for each test/ stage
environment to have its own box.
"Branden Smith" <BradSmith@hotmail.com> wrote in message
news:OLToO%23LiFHA.3656@TK2MSFTNGP09.phx.gbl...
> Installing multiple instances of SQL Server is really good.
> Some one can tell me when exactly those situations arises.
> SQL 2K.
> Thanks,
> Smith
>
>
| |
| Branden Smith 2005-07-14, 8:23 pm |
| What is the necessity of having three instances of SQL Server on one box?
You create all the USER databases in one instance only. What we are gaining
by doing that approach? What is that we are missing by not going to multiple
instances?
Thanks,
Smith
"ChrisR" <noemail@bla.com> wrote in message
news:eqxS2AMiFHA.1444@TK2MSFTNGP10.phx.gbl...
> I have 6 production environments. I have two test boxes, each with 3
> instances of SQL. Same with staging. Just too costly for each test/ stage
> environment to have its own box.
>
>
> "Branden Smith" <BradSmith@hotmail.com> wrote in message
> news:OLToO%23LiFHA.3656@TK2MSFTNGP09.phx.gbl...
>
>
| |
| ChrisR 2005-07-14, 8:23 pm |
| For example, staging is supposed to be a mirror(or as close as possible) of
production. Not even close if only on 1 instance.
"Branden Smith" <BradSmith@hotmail.com> wrote in message
news:%23xthHdMiFHA.2644@TK2MSFTNGP09.phx.gbl...
> What is the necessity of having three instances of SQL Server on one box?
> You create all the USER databases in one instance only. What we are
> gaining
> by doing that approach? What is that we are missing by not going to
> multiple
> instances?
>
> Thanks,
>
> Smith
>
>
> "ChrisR" <noemail@bla.com> wrote in message
> news:eqxS2AMiFHA.1444@TK2MSFTNGP10.phx.gbl...
>
>
|
|
|
|
|