<Eppie> wrote in message news:eHE27g9nEHA.3792@TK2MSFTNGP11.phx.gbl...
> Hi all,
>
> For performance reason, I want to devide all databases over multiple
> instances.
> Say 3 instances in a 4-node cluster(win2K3).Active/Active/Active/Passive
>
> In this case, the application would need to know on which
> VirtualServer/Instance the database resides.
> If there is no way to tell the application, is there a solution within
> SQL(2000) for it to do some kind of redirect to the rightServer/Instance
> where the database does reside ?
>
> I am looking for something similar like Exchange, where all servers in the
> Organisation know where(which server) your mailbox resides.
> So you could connect to any mail server and get directed to the one with
> your mailbox.
>
> Thx,
>
> Erwin
>
>

"Geoff N. Hiten" <SRDBA@Careerbuilder.com> wrote in message
news:OxwJwI%23nEHA.2904@TK2MSFTNGP15.phx.gbl...
> Clustering doesn't work like that. Each instance owns a defined set of
> databases. Each database can be owned by only one instance. The entire
> instance fails as a unit to another host node should the first host node
go
> down. Clustering is not a scale-out technology.
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
>
> I support the Professional Association for SQL Server
> www.sqlpass.org
>
> <Eppie> wrote in message news:eHE27g9nEHA.3792@TK2MSFTNGP11.phx.gbl...
> > Hi all,
> >
> > For performance reason, I want to devide all databases over multiple
> > instances.
> > Say 3 instances in a 4-node cluster(win2K3).Active/Active/Active/Passive
> >
> > In this case, the application would need to know on which
> > VirtualServer/Instance the database resides.
> > If there is no way to tell the application, is there a solution within
> > SQL(2000) for it to do some kind of redirect to the rightServer/Instance
> > where the database does reside ?
> >
> > I am looking for something similar like Exchange, where all servers in
the
> > Organisation know where(which server) your mailbox resides.
> > So you could connect to any mail server and get directed to the one with
> > your mailbox.
> >
> > Thx,
> >
> > Erwin
> >
> >
>
>

"Eppie" wrote:

> Thx,
>
> I understand that.
> I am looking for some kind of solution where you could connect to A database
> without having to know which server(or instance) the database physically
> resides(clustered or non-clustered).
>
> As in the Exchange example, connecting to An Exhange server which will
> redirect you to the server actually holding your mailbox.
>
> It would be a good option for SQL to be able to do this too.
>
> Thx,
>
> Erwin
>
> "Geoff N. Hiten" <SRDBA@Careerbuilder.com> wrote in message
> news:OxwJwI%23nEHA.2904@TK2MSFTNGP15.phx.gbl...
> > Clustering doesn't work like that. Each instance owns a defined set of
> > databases. Each database can be owned by only one instance. The entire
> > instance fails as a unit to another host node should the first host node
> go
> > down. Clustering is not a scale-out technology.
> >
> > --
> > Geoff N. Hiten
> > Microsoft SQL Server MVP
> > Senior Database Administrator
> > Careerbuilder.com
> >
> > I support the Professional Association for SQL Server
> > www.sqlpass.org
> >
> > <Eppie> wrote in message news:eHE27g9nEHA.3792@TK2MSFTNGP11.phx.gbl...
> > > Hi all,
> > >
> > > For performance reason, I want to devide all databases over multiple
> > > instances.
> > > Say 3 instances in a 4-node cluster(win2K3).Active/Active/Active/Passive
> > >
> > > In this case, the application would need to know on which
> > > VirtualServer/Instance the database resides.
> > > If there is no way to tell the application, is there a solution within
> > > SQL(2000) for it to do some kind of redirect to the rightServer/Instance
> > > where the database does reside ?
> > >
> > > I am looking for something similar like Exchange, where all servers in
> the
> > > Organisation know where(which server) your mailbox resides.
> > > So you could connect to any mail server and get directed to the one with
> > > your mailbox.
> > >
> > > Thx,
> > >
> > > Erwin
> > >
> > >
> >
> >
>
>