Re: Type of Cluster?



If you run Active/Active, in the ideal situation you limit the RAM used by
each instance so that in a failover, both (or all three) has avaialble RAM
on its new node to function.

Size and memory requirements would dictate for me what approach to take.

Other opinions may vary...

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm


"rui" <rui@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3F786FD2-AFE4-4F6C-A1A4-71C005C68977@xxxxxxxxxxxxxxxx
> Hi,
>
> I have 3 databases on 3 seperate SQL 2000 servers, all are used heavily.
> There is no high availablity solution.
>
> I was thinking of placing the databases in Windows 2003 Cluster. If I do
> that, in terms of performance shouldn't I use an active\active
> configuration
> (i think it's called multi-instance nowadays). What I am trying to say is
> that each server in the cluster will maintain its own database.
>
> Wouldn't I need a beefed up server to put all databases on a single node
> in
> an active\passive cluster.
>
> I also have use of a SAN
>
> Thanks
>
>


.



Relevant Pages

  • Re: is data mirroing online? exchange2003 cluster
    ... The disk which contains the databases is ... > its own databses in its own physical server). ... > NodeB (because cluster does not replicate). ... >> What you do is setup a set of shared disks that are connected to two ...
    (microsoft.public.exchange2000.setup.installation)
  • Re: is data mirroing online? exchange2003 cluster
    ... The disk which contains the databases is ... > its own databses in its own physical server). ... > NodeB (because cluster does not replicate). ... >> What you do is setup a set of shared disks that are connected to two ...
    (microsoft.public.exchange2000.admin)
  • Re: is data mirroing online? exchange2003 cluster
    ... The disk which contains the databases is ... > its own databses in its own physical server). ... > NodeB (because cluster does not replicate). ... >> What you do is setup a set of shared disks that are connected to two ...
    (microsoft.public.exchange2000.general)
  • RE: Clustering a standalone SQL server + storage array
    ... working as expected with out error your ready to install sql server. ... log files to the data and log shared drives you setup as part of the cluster. ... Our apps team look after a trading system that uses an HP DL360 server ... running SQL 2000 SP3a with a few small databases on it. ...
    (microsoft.public.sqlserver.clustering)
  • Re: upgrading sql2k cluster to sql2005
    ... It ain't that simple for SQL Server. ... that databases get locked off in the current cluster and then properly ...
    (microsoft.public.sqlserver.clustering)