May 18, 2009 at 8:13 am
MSDN States 50 and 16: http://msdn.microsoft.com/en-us/library/cc645993.aspx
May 18, 2009 at 8:36 am
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.
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[/url]
May 18, 2009 at 8:57 am
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: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
May 18, 2009 at 10:05 am
Alright - who wants to volunteer to go and install 50 instances this morning and see what happens? Please name one after me 😀
May 18, 2009 at 10:08 am
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 😀
You mean: "Who wants to try and install as many instances of the Standard Edition as possible?"
🙂
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[/url]
May 18, 2009 at 10:14 am
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: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
May 18, 2009 at 10:22 am
Steve Jones - Editor (5/18/2009)
I'll pass. I'm certainly not going to install51 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.
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[/url]
May 18, 2009 at 10:38 am
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
May 18, 2009 at 10:46 am
This is confusing, especially seeing this page:
http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx
May 18, 2009 at 12:00 pm
I think there was a question on 2005 Enterprise, which was 50 (above the usual 16 in 2000)
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
May 18, 2009 at 2:04 pm
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
May 18, 2009 at 2:09 pm
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.
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[/url]
May 19, 2009 at 6:50 am
.
May 20, 2009 at 2:54 am
Losing the point! :w00t:
Any strong reason why 50 - 50 !? We have documentation that 50 - 16 failover cluster!
:w00t::w00t:
May 25, 2009 at 1:33 am
Noel McKinney (5/18/2009)
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%5B/quote%5D
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
MCSE: Data Platform
Viewing 15 posts - 16 through 30 (of 37 total)
You must be logged in to reply to this topic. Login to reply