SQL Server Performance

SQL Cluster Queries

Discussion in 'SQL Server 2005 Clustering' started by sachinsamuel, Oct 25, 2007.

  1. sachinsamuel New Member

    Hi All,
    I am deciding on high-availibitly for my database server box. My website can get large number of user hits for 4 days in every quater of year. We are also planning to launch some schemes which will help keep are business and servers busy :).
    I am planning to have 2 node cluster. With configuration
    Windows Server 2003 Standard Edition 64 bit
    SQL Server 2005 Standard Edition 64 bit
    4 GB RAM
    8 x 300 GB Ultra 320 SCSI Hard Drives
    Hardware RAID 0+1
    Redundant Controllers
    Fiber Attached
    My Question are.
    1) What type of clustering I should go for? (Active/active vs Active/Clustering) and why?
    2) Will active/active means load balancing as there will be 2 servers as active and both of them can share the load?
    3) What are the advantages and disadvantages of clustering type you recommend in question 1.
    4) We are also planning to configure transactional replication on these servers as per disaster recovery plan.
    Will it an overhead to the servers if they are in different geographical locations? (My network bandwidth is
    100 mbps connection)
    Please help. Thanks in advance.
  2. techbabu303 New Member

  3. satya Moderator

    Do you really need to go with CLUSTER?
    As you are using SQL 2005 why not with other high availability options such as DATABASE MIRRORING in this case. Just a thought!
  4. To_DBA New Member

    does Windows Server 2003 Standard Edition 64 bit support SQL 2005 cluster?

Share This Page