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!

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!