Maximum instances supported by SQL Server 2008

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Manish Sinha » Maximum instances supported by SQL Server...

35 posts, Page 2 of 4

««1 2 3 4 »»»

Maximum instances supported by SQL Server 2008

Rate Topic

Display Mode

Topic Options

Author

Message

craigpessano

Posted Monday, May 18, 2009 6:37 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, May 17, 2013 2:51 PM
Points: 4,003, Visits: 1,485

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?

Post #718992

Noel McKinney

Posted Monday, May 18, 2009 6:56 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, April 05, 2012 2:35 PM
Points: 2,007, Visits: 767

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

Post #719007

Hugo Kornelis

Posted Monday, May 18, 2009 7:17 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 4:30 PM
Points: 5,235, Visits: 7,038

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

Post #719032

Steve Jones - SSC Editor

Posted Monday, May 18, 2009 7:43 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 6:14 PM
Points: 31,421, Visits: 13,734

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: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #719057

Manish Sinha

Posted Monday, May 18, 2009 8:01 AM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, May 05, 2010 10:47 PM
Points: 93, 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. Smile

Who can confirm this?

Post #719077

ghollis

Posted Monday, May 18, 2009 8:13 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, January 12, 2012 12:05 PM
Points: 308, Visits: 126

MSDN States 50 and 16: http://msdn.microsoft.com/en-us/library/cc645993.aspx

Post #719096

Alvin Ramard

Posted Monday, May 18, 2009 8:36 AM

Hall of Fame

Group: General Forum Members
Last Login: Saturday, November 10, 2012 8:24 AM
Points: 3,031, Visits: 7,383

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.

Post #719127

Steve Jones - SSC Editor

Posted Monday, May 18, 2009 8:57 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 6:14 PM
Points: 31,421, Visits: 13,734

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: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #719150

Chad Crawford

Posted Monday, May 18, 2009 10:05 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 4:17 PM
Points: 2,548, Visits: 17,356

Alright - who wants to volunteer to go and install 50 instances this morning and see what happens? Please name one after me :D

Post #719216

Alvin Ramard

Posted Monday, May 18, 2009 10:08 AM

Hall of Fame

Group: General Forum Members
Last Login: Saturday, November 10, 2012 8:24 AM
Points: 3,031, Visits: 7,383

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 :D

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

:)

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.

Post #719219

« Prev Topic | Next Topic »

35 posts, Page 2 of 4

««1 2 3 4 »»»

Permissions