• Replies 6 replies
  • Subscribers 339 subscribers
  • Views 39 views
  • Users 0 members are here
Related

Standard or Enterprise SQL Server

Nick Insell
$organization

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

Parents
  • Former Member
    Former Member $organization

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

     

    Thanks and have a great day!

    Naomi Williams

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Nick Insell
    Sent: Wednesday, May 12, 2010 10:05 AM
    To: Naomi Williams
    Subject: Re: [Tessitura Technical Forum] Standard or Enterprise SQL Server

     

    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!

    From: Naomi Williams <bounce-naomiwilliams9587@tessituranetwork.com>
    Sent: 5/12/2010 9:48:33 AM

    Nick,

    Take a look at this, online indexing, online restoring, hot add memory and so much more, THAT my friend is exciting!

    http://msdn.microsoft.com/en-us/library/cc645993.aspx

    Naomi




    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!

Reply
  • Former Member
    Former Member $organization

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

     

    Thanks and have a great day!

    Naomi Williams

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Nick Insell
    Sent: Wednesday, May 12, 2010 10:05 AM
    To: Naomi Williams
    Subject: Re: [Tessitura Technical Forum] Standard or Enterprise SQL Server

     

    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!

    From: Naomi Williams <bounce-naomiwilliams9587@tessituranetwork.com>
    Sent: 5/12/2010 9:48:33 AM

    Nick,

    Take a look at this, online indexing, online restoring, hot add memory and so much more, THAT my friend is exciting!

    http://msdn.microsoft.com/en-us/library/cc645993.aspx

    Naomi




    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!

Children
No Data