SQL Server Performance

Building my first SQL Server 2005 2-node Cluster

Discussion in 'SQL Server 2005 Clustering' started by arenas87058, Nov 26, 2008.

  1. arenas87058 New Member

    Hey Guys,
    I'm building my first SQL 2005 64-bit cluster. I want it to be a complete success. What info do I need ahead of time? I'm specifically talking about the different service accounts that weren't there for SQL 2000 clustering.
    Much thanks in advance,
    A
  2. Elisabeth Redei New Member

    Hi A,
    Excellent ambition! First step is, as you already know if you have setup SQL Server 2000 in a cluster, is to make sure the cluster and especially the shared drives are impeccable. Next step, if this is Windows 2003, is to get the MSDTC sorted.
    For the 2005 specific; make sure there is no GPO in place that can mess up your accounts (such as a GPO that will prevent the startup accounts you choose from acquiring certain rights). One good idea is to put your SQL Servers in a separate OU in the domain. The setup will take of creating the right groups for you.
    There is a whitepaper out there "Failover Clustering for Microsoft SQL Server 2005 and SQL Server 2005 Analysis Services", http://www.microsoft.com/downloads/...dc-a17b-4f09-b282-c6830fead499&DisplayLang=en. You might want to browse through it.
    HTH!
    /Elisabeth
  3. Elisabeth Redei New Member

    Hi A,
    Excellent ambition! First step, which you already know if you have setup SQL 2000 on a cluster, is to make sure the Cluster and the shared drives are impeccable. Next step, if you are on Windows 2003, is to sort out MSDTC.
    For the 2005 specifics, make sure there is no GPO in place that can prevent the startup accounts you choose from acquiring certain rights. A good idea is to keep your SQL Servers (and other servers) in a separate OU in the domain. The setup will take care of setting up the groups.
    There is a comprehensive whitepaper "Failover Clustering for Microsoft SQL Server 2005 and SQL Server 2005 Analysis Services", http://www.microsoft.com/downloads/...dc-a17b-4f09-b282-c6830fead499&DisplayLang=en. You should probably browse through that.
    HTH!
    /Elisabeth
  4. arenas87058 New Member

    Thanks for the advice. But what are:
    1. GPO
    2. OU
    Thanks,
    A
  5. satya Moderator

  6. satya Moderator

    First of all I believe this is not an Analysis services installation, so the above whitepaper will help to some extent to build up the clusters on operating system level.
    Brad McGeehee, MVP has written an excellent article in this regard - http://www.sql-server-performance.com/articles/clustering/cluster_sql_server_2005_p1.aspx and all the latest cluster based articles can be found http://www.sql-server-performance.com/articles/clustering/main.aspx here.
    Also the related Clustering based references are here:
    Mount Points and Clustering blurb for SQL Server & windows operating system

    Is RAID5 better for performance when SQL Server Clustering and SAN is involved?

    SQL Server configuration disk layout - best practices from field

    SQL Server database upgrade - FAQs, How-to, Gotchas, links and blurb this is for specific on upgrade FAQs.

    Get SQL Server Clustering information with DMVs and SELECT statements

  7. arenas87058 New Member

    Thanks a ton.
    A

Share This Page