Maximum instances supported by SQL Server 2008

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

  • 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?

  • 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]

  • 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]

  • 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".

  • 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/

  • Yes question is wrongly worded.

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

  • 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

  • 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.

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

  • 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?

  • 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

  • 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/

  • 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.

  • 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 37 total)

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