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 Monday, May 18, 2009 10:14 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 6:37 PM
Points: 33,189, Visits: 15,329
I'll pass. I'm certainly not going to install

51 on Enterprise
51 on standard (or 17 if it fails)
17 on Workgroup.

Perhaps Ed Vassie, with his automated install utility will try.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #719227
Posted Monday, May 18, 2009 10:22 AM


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: Yesterday @ 4:01 PM
Points: 3,153, Visits: 8,007
Steve Jones - Editor (5/18/2009)
I'll pass. I'm certainly not going to install

51 on Enterprise
51 on standard (or 17 if it fails)
17 on Workgroup.

Perhaps Ed Vassie, with his automated install utility will try.


The script needs to be able to create a new instance name each time.

I'm passing on it too.




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 #719236
Posted Monday, May 18, 2009 10:38 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 7:37 AM
Points: 1,509, Visits: 2,163
Didn't we have a question about how many instances you can install a few months ago? Or was the one I'm thinking of for 2005?

Jason Shadonix
MCTS, SQL 2005
Post #719256
Posted Monday, May 18, 2009 10:46 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 6:13 AM
Points: 2,878, Visits: 468
This is confusing, especially seeing this page:

http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx



Post #719263
Posted Monday, May 18, 2009 12:00 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 6:37 PM
Points: 33,189, Visits: 15,329
I think there was a question on 2005 Enterprise, which was 50 (above the usual 16 in 2000)








Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #719311
Posted Monday, May 18, 2009 2:04 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 12:59 PM
Points: 186, Visits: 372
Perhaps I am confused or simply don't understand the question or have a bad reference source.

The whitepaper "SQL Server Consolidation with SQL Server 2008"
Writer: Martin Ellis
Reviewer: Prem Mehra,Lindsey Allen, Tiffany Wissner, Sambit Samal

Published: March 2009
Applies to: SQL Server 2008

page ten, lists

Edition Maximum instances
SQL Server 2008 Standard 16*
SQL Server 2008 Enterprise 50*
*Depending upon available system resources and workload



Post #719401
Posted Monday, May 18, 2009 2: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: Yesterday @ 4:01 PM
Points: 3,153, Visits: 8,007
zzx375 (5/18/2009)
Perhaps I am confused or simply don't understand the question or have a bad reference source.

The whitepaper "SQL Server Consolidation with SQL Server 2008"
Writer: Martin Ellis
Reviewer: Prem Mehra,Lindsey Allen, Tiffany Wissner, Sambit Samal

Published: March 2009
Applies to: SQL Server 2008

page ten, lists

Edition Maximum instances
SQL Server 2008 Standard 16*
SQL Server 2008 Enterprise 50*
*Depending upon available system resources and workload


Check out the link below. It's the one referenced in the answer. It states both Enterprise and Standard can handle 50.

[url=http://msdn.microsoft.com/en-us/library/ms143432.aspx][/url]




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 #719404
Posted Tuesday, May 19, 2009 6:50 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 6, 2012 7:34 AM
Points: 1, Visits: 36
.
Post #719739
Posted Wednesday, May 20, 2009 2:54 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 1:51 AM
Points: 1,262, Visits: 3,422
Losing the point!

Any strong reason why 50 - 50 !? We have documentation that 50 - 16 failover cluster!



============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #720385
Posted Monday, May 25, 2009 1:33 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 3, 2014 2:45 AM
Points: 2,531, Visits: 536
Noel McKinney (5/18/2009)
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


I agree, there is a mismatch between BOL and http://msdn.microsoft.com/en-us/library/ms143432.aspx

/Håkan


/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
Post #722864
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse