Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

Maximum instances supported by SQL Server 2008 Expand / Collapse
Author
Message
Posted Sunday, May 17, 2009 3:42 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, May 5, 2010 10:47 PM
Points: 93, Visits: 98
Comments posted to this topic are about the item Maximum instances supported by SQL Server 2008
Post #718612
Posted Sunday, May 17, 2009 3:45 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, September 19, 2014 2:49 AM
Points: 1,085, Visits: 277
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?
Post #718613
Posted Sunday, May 17, 2009 7:48 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, September 19, 2014 3:41 PM
Points: 1,410, Visits: 8,095
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

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 #718665
Posted Sunday, May 17, 2009 9:09 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 5:48 AM
Points: 3,241, Visits: 5,002
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


----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Sometimes, winning is not an issue but trying.

You can check my BLOG here

Post #718778
Posted Sunday, May 17, 2009 9:28 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 4:34 PM
Points: 20,676, Visits: 32,269
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

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #718784
Posted Monday, May 18, 2009 1:28 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, September 18, 2014 1:36 PM
Points: 6,002, Visits: 8,267
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.

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



Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #718840
Posted Monday, May 18, 2009 3:17 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Sunday, August 3, 2014 3:41 PM
Points: 1,219, Visits: 1,430
Yes question is wrongly worded.
But to top answer was the only one with the two numbers 50 & 16 so i ventured a guess.
Post #718895
Posted Monday, May 18, 2009 4:08 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, September 15, 2014 1:13 AM
Points: 1,535, Visits: 2,577
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
Post #718910
Posted Monday, May 18, 2009 6:26 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, April 19, 2011 7:31 AM
Points: 2,666, Visits: 5,316
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.
Post #718985
Posted Monday, May 18, 2009 6:28 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, November 29, 2010 7:15 AM
Points: 331, Visits: 62
I agree with everyone. None of the answers is right, though the first was intended to be the correct one.
Post #718986
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse