SQL Server Performance

Standard or Enterprise for what I am trying to do?

Discussion in 'SQL Server 2005 Clustering' started by Torn, Mar 29, 2007.

  1. Torn New Member

    We are wanting to use a 4 node Windows 2003 Enterprise cluster with 3 (2 node each) SQL Server 2005 Standard instances. I fully understand the physical requirements of setting this up.

    Node 1 would fail to Node 4
    Node 2 would fail to Node 4
    Node 3 would fail to Node 4

    Node 4 is the passive fail-over for all three SQL Server 2005 (standard) instances.

    This setup should only require the standard version of SQL Server 2005 since each SQL cluster only has 2 nodes; am I correct in this assumption?

    Please no speculation, I am looking for replies from folks who know for sure.

    Yes, I have read Brad M. McGehee's article "How to Cluster SQL Server 2005" but the article fails to mention the versions (of SQL server 2005) required in the section "Installing Clustering on Multiple Nodes".

    This is more than anything a budgeting concern as we are trying to make the most of using 2005 Standard and completely avoid purchasing Enterprise.

  2. bradmcgehee New Member

    If you want to cluster more than two nodes, you must have the Enterprise version of the OS and SQL Server 2005.

    Brad M. McGehee, SQL Server MVP
  3. Torn New Member

    4 Node Windows cluster - Enterprise: Yes
    2 Node SQL 2005 Cluster (within that 4 Node Windows Cluster) - ?

    Standard should be sufficient since the active nodes in that instanced SQL cluster are only 2.

    Has anyone already tried this specific setup?
  4. MohammedU New Member

    I don't think it is going to work...
    SQL SERVER 2005 standard support only two node cluster where as when you install MSCS it will be 4 node...

  5. Torn New Member

    I got it to work. A single (3 node) Windows 2003 Enterprise cluster containing 2 (2 node) SQL Server 2005 Standard Clusters.

    server1(instance A) fails to server3(instance A)
    server2(instance B) fails to server3(instance B)

    I knew it was possible with only SQL Server Standard!

    Talk about saving a massive amount on licensing.
  6. MohammedU New Member

    Thanks for sharing the info and it is very good news...

    Check with MS about licencing and make sure you don't break any licence agreement...

  7. Torn New Member

    It's not.
  8. MohammedU New Member

    Cool...<br />$$$ Saving <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />MohammedU.<br />Moderator<br />SQL-Server-Performance.com<br /><br />All postings are provided “AS IS” with no warranties for accuracy.<br />
  9. satya Moderator

Share This Page