MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

SQL server 2005 enterprise vs. standard edition for large MOSS 2007

  Asked By: Karissa    Date: Aug 11    Category: MOSS    Views: 1472

Currently we have a large SharePoint 2003 farm with a two node SQL
cluster. We required SQL 2000 enterprise edition for the clustering. We
are planning to migrate to WSS 3 and MOSS 2007 to a new 12 server farm -
again with a two node SQL 2005 cluster. Since the standard edition of
SQL 2005 provides 2 node clustering is there anyone using any of the
features of SQL 2005 enterprise edition in their MOSS 2007 / WSS 3
server farms?



5 Answers Found

Answer #1    Answered By: Irving Hurley     Answered On: Aug 11

For WSS/SPS/MOSS, the database is just a secure, transactional repository. They
don't capitalize on or prohibit the use of ancillary capabilities (like cubes).
What features are you looking to use?

Answer #2    Answered By: Yvonne Rodriquez     Answered On: Aug 11

I realize that this thread was abandoned however, the question comes
forth once more regarding SQL Server Enterprise edition  versus
Standard edition and what the recommendation is.

Much like the original poster, we've used SQL EE 00 for the clustering
capability. Is there any wow or really good reason to go with SQL EE
05 for MOSS 2007 large  farm implementations?

Answer #3    Answered By: Elisha Abbott     Answered On: Aug 11

The amount of memory you can use ?

Answer #4    Answered By: Naimish Ranganekar     Answered On: Aug 11

Well, its not the amount of memory

You can get a product comparison here


Large (>500Gb) db fast query support could be important if you have huge db's

Database snapshots could be useful

The mirroring in enterprise  is better than with standard  - mirroring generally
has faster failover than clustering which has to replay all of your log files
and is cheaper to set up

Generally, I think Enterprise is useful for very large  DB's (in the Tb range)
so if you distribute your site collections amongst DB's and put enough memory in
and have a fats disk sub-system, I don’t know that there's any real benefit
with a reasonable sized moss  implementation - i.e. while there are some benefits
I don't know that they outweigh the cost of the editions.

Answer #5    Answered By: Caleb Gordon     Answered On: Aug 11

Thanks for replying to this old post of mine. We still have a little time before
having to choose which version of SQL 2005 to purchase so if anyone else has an
opinion or experience with this issue - please me know