Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Maximum instances supported by SQL Server 2008


Maximum instances supported by SQL Server 2008

Author
Message
craigpessano
craigpessano
SSCertifiable
SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)

Group: General Forum Members
Points: 5002 Visits: 2276
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.

[url=http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx][/url]

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
Noel McKinney
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2015 Visits: 796
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
Hugo Kornelis
SSCrazy Eights
SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)

Group: General Forum Members
Points: 8289 Visits: 11536
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 MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)

Group: Administrators
Points: 35891 Visits: 18718
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.

Follow me on Twitter: @way0utwestForum Etiquette: How to post data/code on a forum to get the best help
Manish Sinha
Manish Sinha
SSC Journeyman
SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)

Group: General Forum Members
Points: 95 Visits: 98
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?
ghollis
ghollis
Old Hand
Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)

Group: General Forum Members
Points: 311 Visits: 127
MSDN States 50 and 16: http://msdn.microsoft.com/en-us/library/cc645993.aspx
Alvin Ramard
Alvin Ramard
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2667 Visits: 11585
How can we be expected to know what the right answer is when Microsoft is reporting different answers?

Once again, there's your evidence that bigger is not always better.



Alvin Ramard
Memphis PASS Chapter

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
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)

Group: Administrators
Points: 35891 Visits: 18718
It's harder to maintain things as they grow, and this is a good example. BOL is built by a team, and my guess is someone copied the documentation from 2005, thinking that it hadn't changed. Someone else changed docs, and who knows what was the final marketing/technical decision.

I will award back all points since the question was misworded once I have a good answer from MS.

Follow me on Twitter: @way0utwestForum Etiquette: How to post data/code on a forum to get the best help
Chad Crawford
 Chad Crawford
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2436 Visits: 18644
Alright - who wants to volunteer to go and install 50 instances this morning and see what happens? Please name one after me BigGrin
Alvin Ramard
Alvin Ramard
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2667 Visits: 11585
Chad Crawford (5/18/2009)
Alright - who wants to volunteer to go and install 50 instances this morning and see what happens? Please name one after me BigGrin


You mean: "Who wants to try and install as many instances of the Standard Edition as possible?"

Smile



Alvin Ramard
Memphis PASS Chapter

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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search