3/4 Node Clustering

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Kamal Hassan (Hassan_at_discussions.microsoft.com)
Date: 02/15/05 

Date: Tue, 15 Feb 2005 08:07:03 -0800

Hi,

We plan to install/setup 3-4 node SQL Clustering using Windows 2003
(Enterprise Edition)/SQL2000 (Enterprise Edition) on SAN (EMC)

we plan to initially setup/install clustering using two servers (S1& S2) as
an ACTIVE/PASSIVE and then later add third (S3) as ACTIVE with S2 as Standby
(remain PASSIVE) and may be fourth one later...

We want it to make sure that we have the DISK resources setup/assigned
appropriately so we do not have any issues with above configurations.

We have 3 storage groups (sg1, sg2, sg3) 100 GB (RAID5) for SQL Data each
server.
We have 2 storage group (sg1, sg2) 33 GB (RAID1) for SQL Log

Need advice on following:

Drive letter assignment (SQL Data)
Drive Letter assignment (SQL Log)
We plan to use single QUORUM disk (Q:) for all NODES.

Any suggestions/advice would be greatly appreciated.

Thanks.

kamal.h@pointclickcare.com

Relevant Pages

  • Re: sp_recompile issue
    ... once it selected a plan suitable for processing large quantities of data it was not able to see that it needed a new plan for the parameters that processed small amounts of data. ... It is certainly true that linked servers can add significant headaches. ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.programming)
  • Re: Disaster Recovery Planning
    ... This isn't a DR plan per say but does cover a lot of the areas you need to ... Andrew J. Kelly SQL MVP "Cqlboy" wrote in message ... >> I've set up an active/active SQL cluster in our DR site and am using log>> shipping to keep the DR databases in sync with the production DBs;>> combined with MDAC aliases, non-standard TCP ports for SQL & DNS aliases>> for the server names to allow to very quick, transparent redirection of>> client connections to the DR servers in the event of a disaster. ...
    (microsoft.public.sqlserver.server)
  • Re: sql 2005 with Sharepoint
    ... Right now we have 3 servers using for WSS, sharepoint and database. ... we plan like clustering as well as load balancing also. ... >> Right now we have Sharepoint 2003 with sql 2000 and working fine. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Adding a 3rd and 4th node to Win2k3 cluster
    ... >> servers run SQL and another ERP application called iRenaissance. ... > It sounds like a good plan to me. ... > You add the two new nodes to the cluster first, ...
    (microsoft.public.windows.server.clustering)
  • Re: SP runs slower than same query in Query analyzer. Why??
    ... Andrew your reply was useful but I'm quite new to sql server and I'm ... query gives me the results in 3-4 seconds. ... > Keep in mind that the server has to compile a complete execution plan ... > when compiling a plan. ...
    (microsoft.public.sqlserver.clients)