Maximum instances supported by SQL Server 2008

Question

Maximum instances supported by SQL Server 2008

Manish Sinha

Ten Centuries

Points: 1023
More actions
May 17, 2009 at 3:42 am

#384602

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

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

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

Tim Reddish Ten Centuries Points: 1311 More actions · Answer 1

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 More actions · Answer 2

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 More actions · Answer 3

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: 442467 More actions · Answer 4

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: 64790 More actions · Answer 5

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: 11543 More actions · Answer 6

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 More actions · Answer 7

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 More actions · Answer 8

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: 569 More actions · Answer 9

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

craigpessano SSCertifiable Points: 5358 More actions · Answer 10

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: 3452 More actions · Answer 11

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: 64790 More actions · Answer 12

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: 736172 More actions · Answer 13

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 More actions · Answer 14

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?