Standard or Enterprise SQL Server

I know that for our consortium we will certainly go for Enterprise. 

The Hyper-V support is something we definitely want since we are nearly fully virtualized, but we ultimately want to keep our options open for scalability.  We use a two-node cluster now, we may in the future want to do more than that, which would require Enterprise.   We have a four CPU DB server now, who knows, we may want a bigger one with more CPUs when/if we add new members.  That would require Enterprise as well. 

We’re also always on the lookout for new members, and having things scalable keeps incoming costs for new members lower.

Plus some of the new features – as Naomi noted – are pretty cool.  And since we are really delving into T-Stats it behooves use to have as much Analysis Services toys to play with as possible.

But that’s just us.

MH

matt_hilgers@milwaukeeartspartners.org

IM:  matt_hilgers

Afternoon

I have a question for SQL Geeks

We are looking in to the costs of upgrading from SQL Server 2005 to 2008 and have found that the cost of SQL Server Enterprise is much greater than Standard.  Looking online at the differecences between the two editions I have noticed that enterprise includes the following features;

• Hypervisor support (in Hyper-V)
• Database snapshots
• Indexed views
• Resource governor
• Compression (both data and backup)
• Partitioning
• Transparent Encryption with 3rd party key management
• Transaction auditing (excellent for compliance)
• Change data capture
• Report scale-out
• Grouped server management (one command can be sent to multiple servers)

I'm not sure whether these are important and whether Tessitura needs these features.  What is everyone going for in their upgrades?

Thanks

Nick

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Anyway you will “need” to have a clustered environment for high availability and performance purposes?

Thanks and have a great day!

Naomi Williams

The only problem with these are they are nice to haves rather than essential for performance.

Still haven't found anything that means that we can justify getting Enterprise over standard.  Though would love Enterprise!

For what it’s worth, we’re finding great appeal the new Business Intelligence features in the Enterprise edition, particularly the capabilities they offer in terms of integration with Microsoft Office and with SharePoint.     If this is an area of interest to you, you might want to look more closely at what the Enterprise edition offers here and see if that tips the value equation.

Alan C. Levine

Chief Information Officer

The John. F. Kennedy Center for the Performing Arts

2700 F St NW

Washington, DC 20566

(202) 416-8688

aclevine@kennedy-center.org                           Office Communicator

twitter:  @aclevine

www.kennedy-center.org

www.nationalsymphony.org

www.artsmanager.org