SQL Server Performance

Licensing in Clustering

Discussion in 'SQL Server 2005 Clustering' started by Fais, Jan 14, 2008.

  1. Fais New Member

    Hi all,
    Please correct me , If I am wrong:
    1) In SQL Server 2005 Clustering ( Active-Passive), only the Active instance need the license, as long as the Passive instance have same number of processors (or) less than active.
    2) If we install , additional instance of SQL Server Enterprise edtion in Clustering, then we don’t need to have any addional licence for the named instances.
    3) Data files on SAN à RAID 10
    4) Log files on SAN à RAID 1 (or) RAID 10.
  2. satya Moderator

    1) Yes, provided you must have similar number of CPU if the licensing is server based. Passive can have less number for the license number and should not be more than active one.
    2) For every instance you install must have licensing and it is not for the windows operating system, it is with SQL Server instance service. As both of the instance work independently.
    3) & 4) Yes
    FYI - http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part2/c0461.mspx & http://www.microsoft.com/sql/howtobuy/default.mspx on licensing. http://www.sql-server-performance.com/articles/clustering/designing_sqlserver_cluster_p2.aspx too.
  3. Fais New Member

    When licensed Per ProcessorWorkgroup, Standard, and Enterprise Editions allow for unlimited instances in each virtual or physical operating environment.
    For Workgroup, Standard and enterprise edition, each virtual operating environment running SQL Server 2005 must have a processor license for each processor that the virtual machine accesses. If a copy of SQL is running on a physical operating environment, then processor licenses are required for all of the processors on that physical server. For enterprise edition there is an added option : if all processors in a machine have been licensed, then the customer may run unlimited instances of SQL server 2005 on an unlimited number of virtual operating environments on that same machine. ( Refer Page 3 below)
    Thisis from: http://download.microsoft.com/download/e/c/a/ecafe5d1-b514-48ab-93eb-61377df9c5c2/SQLServer2005Licensingv1.1.doc
    Does this does not mean that, Named instances ( when sql server is licensed per processor as in our case), does not need any addtional license.
    Its a little bit confusing, please clear this.
  4. satya Moderator

    They are free to run on Virtual environment and I'm sure not for physical machines, better to contact local MS account support or call up CSS.

Share This Page