Currently we have a large SharePoint 2003 farm with a two node SQLcluster. We required SQL 2000 enterprise edition for the clustering. Weare 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 ofSQL 2005 provides 2 node clustering is there anyone using any of thefeatures of SQL 2005 enterprise edition in their MOSS 2007 / WSS 3server farms?
For WSS/SPS/MOSS, the database is just a secure, transactional repository. Theydon't capitalize on or prohibit the use of ancillary capabilities (like cubes).What features are you looking to use?
I realize that this thread was abandoned however, the question comesforth once more regarding SQL Server Enterprise edition versusStandard edition and what the recommendation is.Much like the original poster, we've used SQL EE 00 for the clusteringcapability. Is there any wow or really good reason to go with SQL EE05 for MOSS 2007 large farm implementations?
The amount of memory you can use ?
Well, its not the amount of memoryYou can get a product comparison herewww.microsoft.com/.../comparison.mspxLarge (>500Gb) db fast query support could be important if you have huge db'sDatabase snapshots could be usefulThe mirroring in enterprise is better than with standard - mirroring generallyhas faster failover than clustering which has to replay all of your log filesand is cheaper to set upGenerally, 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 inand have a fats disk sub-system, I don’t know that there's any real benefitwith a reasonable sized moss implementation - i.e. while there are some benefitsI don't know that they outweigh the cost of the editions.
Thanks for replying to this old post of mine. We still have a little time beforehaving to choose which version of SQL 2005 to purchase so if anyone else has anopinion or experience with this issue - please me know