Maximum instances supported by SQL Server 2008

  • Manish Sinha

    Ten Centuries

    Points: 1023

    Comments posted to this topic are about the item Maximum instances supported by SQL Server 2008

  • Tim Reddish

    Ten Centuries

    Points: 1311

    I was of the opinion that both standard edition and enterprise edition supported 50 instances, and workgroup edition supports 16 instances.

    Thought that the question was worded incorrectly.

    Does anyone agree?

  • Alvin Ramard

    SSC-Forever

    Points: 41190

    timr (5/17/2009)


    I was of the opinion that both standard edition and enterprise edition supported 50 instances, and workgroup edition supports 16 instances.

    Thought that the question was worded incorrectly.

    Does anyone agree?

    That's what I found too. Enterprise and Standard Editions support the same number.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • Atif-ullah Sheikh

    SSChampion

    Points: 12495

    There was no right choice to select so I selected the first option And GOT THE POINT...but the answer is wrong.

    Both editions support 50 instances Workgroup Edition supports 16 instances on 32 bit SQL Server.

    http://msdn.microsoft.com/en-us/library/ms143432.aspx">

    http://msdn.microsoft.com/en-us/library/ms143432.aspx

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG
    [font="Arial Black"]here[/font][/url][/right]

  • Lynn Pettis

    SSC Guru

    Points: 442118

    I have to agree, the wording of the question is questionable.

    Directly from the source sighted in the answer to the question:

    50 instances on a stand-alone server for all SQL Server editions except for Workgroup. Workgroup supports a maximum of 16 instances per computer.

    SQL Server supports 25 instances on a failover cluster.

    By the way, I did get the question "correct".

  • Hugo Kornelis

    SSC Guru

    Points: 64645

    Lynn Pettis (5/17/2009)


    I have to agree, the wording of the question is questionable.

    Questionable? It's not questionable, it's plain wrong.:angry:

    Standard edition supports 50 instances. Workgroup edition is limited to 16.

    Standard != Workgroup.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • Tom257

    SSChampion

    Points: 11475

    Yes question is wrongly worded.

    But to top answer was the only one with the two numbers 50 & 16 so i ventured a guess.

  • Joy Smith San

    SSC-Insane

    Points: 24877

    50 instances on a stand-alone server for all SQL Server editions except for Workgroup. Workgroup supports a maximum of 16 instances per computer.

    Plese see the beloq link

    http://msdn.microsoft.com/en-us/library/ms143432.aspx

  • tosscrosby

    SSCoach

    Points: 18045

    Alvin Ramard (5/17/2009)


    timr (5/17/2009)


    I was of the opinion that both standard edition and enterprise edition supported 50 instances, and workgroup edition supports 16 instances.

    Thought that the question was worded incorrectly.

    Does anyone agree?

    That's what I found too. Enterprise and Standard Editions support the same number.

    I agree with all the repsonses, so far, as well. Seems to be a common occurence lately with some of the QOTDs.

    -- You can't be late until you show up.

  • dstemate

    Mr or Mrs. 500

    Points: 559

    I agree with everyone. None of the answers is right, though the first was intended to be the correct one.

  • craigpessano

    SSCertifiable

    Points: 5358

    I was thrown off too. The documentation is inconsistent.

    At first I found the capacity limitations page that indicates 50 instances on a stand-alone server for all SQL Server editions except for Workgroup. Workgroup supports a maximum of 16 instances per computer.

    Since this didn't match any of the answers I did a little more digging and found the following link that indicates 50 for Enterprise, and 16 for Standard and other editions.

    I lucked out getting the right answer only because 50 and 50 wasn't one of the choices. Anyone even have this many instances installed to know the true answer?

  • Noel McKinney

    Hall of Fame

    Points: 3377

    The page below (under "Scalability & Performance") gives 50 for Enterprise and 16 for Standard edition:

    http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx

    I had seen the comparison above and got the question right. However, unless I'm missing something, this does seem to contradict the page referenced by the answer's explanation (from the BOL) at

    http://msdn.microsoft.com/en-us/library/ms143432.aspx

  • Hugo Kornelis

    SSC Guru

    Points: 64645

    craigpessano (5/18/2009)


    I did a little more digging and found the following link that indicates 50 for Enterprise, and 16 for Standard and other editions.

    Good catch! (Goes for Noel too).

    I'll ping some of my contacts within Microsoft to see if I can come up with the definitive answer as to which version of their own documentation is correct.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715107

    Pending a definitive answer, I have left things alone for now.

    Once I have one, I'll adjust the question and account for 64bit as well, which just lists 50 instances.

  • Manish Sinha

    Ten Centuries

    Points: 1023

    I have a comparison chart of Enterproise and Standard edition which also says that the number of instances supported are 50 and 16 respectively. 🙂

    Who can confirm this?

Viewing 15 posts - 1 through 15 (of 38 total)

You must be logged in to reply to this topic. Login to reply