none
SQL server upgrade RRS feed

  • Question

  • hi Guys,

    Now i am running my production system on SQL server 2014 standard edition.

    size almost 10TB

    planning to upgrade to 2016 or 2017 or 2019 enterprise edition

    two things i needed suggestion, first is, which should i prefer to go for 2016 or 2017 or 2019 and why like stability or feedback.

    second thing is, cost is not a big issue but still require additional cost differences for each of them.

    i would really appreciate if info can be shared with experience or findings


    SQL Server DBA

    Wednesday, July 17, 2019 3:36 PM

All replies

  • Hi Zeal DBA,

    >> first is, which should i prefer to go for 2016 or 2017 or 2019 and why like stability or feedback.. 

    I suggest you upgrade SQL server 2014 to 2017. SQL server 2017 is more new and stable that SQL 2016. SQL Server 2019 isn't finally released, it's still preview Community Technology Preview state. It is not stable than SQL server 2017.

    >> second thing is, cost is not a big issue but still require additional cost differences for each of them.

    For detailed information about the cost of  license, 
    Please call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist. For international customers, please use the Guide to Worldwide Microsoft Licensing Sites to find contact information in your locations.

    Hope this could help you.

    Best regards,
    Cathy Ji 

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Proposed as answer by Tom Phillips Thursday, July 18, 2019 1:19 PM
    Thursday, July 18, 2019 2:27 AM
  • Request you to provide an email ID for Microsoft licensing specialist.

    SQL Server DBA

    Thursday, July 18, 2019 12:48 PM
  • Hi,

    Upgrading to 2017 would be wiser option than 2016. Please read the link https://sqlperformance.com/2018/04/sql-server-2017/reasons-to-upgrade-to-sql-server-2017

    Regarding your second question,  Enterprise is very expensive, approximately $14K per core. Best thing is to contact regional MS license team.


    Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

    Thursday, July 18, 2019 12:57 PM
  • How does pricing is done for production whether we pay one time while buying product or we have to pay every year till the time we run sql server on production

    SQL Server DBA

    Thursday, July 18, 2019 2:04 PM
  • Request you to provide an email ID for Microsoft licensing specialist.

    SQL Server DBA

    Hi Zeal DBA,

    I think speaking directly to a Microsoft licensing specialist can get better help. They can help you all the issues about the price of license. 

    By the way, we generally do not provide email addresses in the forum. Thanks for your understanding.

    Best regards,
    Cathy Ji

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Proposed as answer by YKN123 Monday, July 22, 2019 8:33 AM
    Friday, July 19, 2019 2:25 AM