SQL Clone
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
Steve Jones
Steve Jones
SSC Guru
SSC Guru (142K reputation)SSC Guru (142K reputation)SSC Guru (142K reputation)SSC Guru (142K reputation)SSC Guru (142K reputation)SSC Guru (142K reputation)SSC Guru (142K reputation)SSC Guru (142K reputation)

Group: Administrators
Points: 142622 Visits: 19424
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
My Blog: www.voiceofthedba.com
Alvin Ramard
Alvin Ramard
SSCrazy Eights
SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)

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

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
TheRedneckDBA
TheRedneckDBA
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4141 Visits: 2613
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?

The Redneck DBA
dgabele
dgabele
Hall of Fame
Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)

Group: General Forum Members
Points: 3945 Visits: 667
This is confusing, especially seeing this page:

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



Steve Jones
Steve Jones
SSC Guru
SSC Guru (142K reputation)SSC Guru (142K reputation)SSC Guru (142K reputation)SSC Guru (142K reputation)SSC Guru (142K reputation)SSC Guru (142K reputation)SSC Guru (142K reputation)SSC Guru (142K reputation)

Group: Administrators
Points: 142622 Visits: 19424
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
My Blog: www.voiceofthedba.com
John Langston
John Langston
SSC-Addicted
SSC-Addicted (476 reputation)SSC-Addicted (476 reputation)SSC-Addicted (476 reputation)SSC-Addicted (476 reputation)SSC-Addicted (476 reputation)SSC-Addicted (476 reputation)SSC-Addicted (476 reputation)SSC-Addicted (476 reputation)

Group: General Forum Members
Points: 476 Visits: 525
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



Alvin Ramard
Alvin Ramard
SSCrazy Eights
SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)

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

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
Jeff Raybould-452044
Jeff Raybould-452044
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 36
.
Dugi
Dugi
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4606 Visits: 3511
Losing the point! w00t

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

w00tw00t

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/
hakan.winther
hakan.winther
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3301 Visits: 612
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
MCITPBigGrinatabase Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
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