• Replies 6 replies
  • Subscribers 339 subscribers
  • Views 34 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
  • $organization

    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                          cid:image004.jpg@01CAE16C.2EF7F4C0 Office Communicator

    twitter:  @aclevine

     

    www.kennedy-center.org

    www.nationalsymphony.org

    www.artsmanager.org

     

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Naomi Williams
    Sent: Wednesday, May 12, 2010 11:15 AM
    To: Levine, Alan
    Subject: RE: [Tessitura Technical Forum] Standard or Enterprise SQL Server

     

    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!




    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!


    This e-mail message is intended only for the recipient(s) named above. This message may contain trade secrets, attorney-client communication, or other privileged and confidential information. Any review, re-transmission, dissemination, reproduction or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the Sender and delete the material from any computer.
Reply
  • $organization

    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                          cid:image004.jpg@01CAE16C.2EF7F4C0 Office Communicator

    twitter:  @aclevine

     

    www.kennedy-center.org

    www.nationalsymphony.org

    www.artsmanager.org

     

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Naomi Williams
    Sent: Wednesday, May 12, 2010 11:15 AM
    To: Levine, Alan
    Subject: RE: [Tessitura Technical Forum] Standard or Enterprise SQL Server

     

    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!




    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!


    This e-mail message is intended only for the recipient(s) named above. This message may contain trade secrets, attorney-client communication, or other privileged and confidential information. Any review, re-transmission, dissemination, reproduction or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the Sender and delete the material from any computer.
Children
No Data