Post reply

2014 vs 2016 ?

  • January 15, 2017 at 10:20 pm

    #320585

    Hi All,

    At the moment our SQL servers are 2008 R2 and we have a plan to upgrade to 2014 or 2016   
    Which one is the best ?
    2014 or 2016 ? if we upgrade to 2014 it will be 3 years behind now but if we upgrade to 2016 ..we are afraid there will be many bugs or issues that have not been found out

    Any feedback are much appreciated
    Many thanks !

  • January 15, 2017 at 11:10 pm

    #1922874

    I would go directly to Sql Server 2016, it is IMHO by far the best ever and so far I haven't heard of any serious bugs.
    😎

  • January 16, 2017 at 1:56 am

    #1922895

    Upgrade to SQL 2016, because Query Store
    and some other nice features including the availability of some previously Enterprise-only features in Standard and Express with SP1.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 16, 2017 at 2:41 am

    #1922911

    WhiteLotus - Sunday, January 15, 2017 10:20 PM

     ..we are afraid there will be many bugs or issues that have not been found out

    So test your systems rigorously on 2016 to find if there are any potential issues for your systems, before actually committing to the upgrade. With software this complex there are always bugs and issues - its whether your system is affected by them that matters.

    Steve Hall
    Linkedin
    Blog Site

  • January 18, 2017 at 5:06 pm

    #1923576

    Thanks for the reply guys . really appreciate it !
    Anyone knows how to get the license cost information ?

  • January 19, 2017 at 10:20 pm

    This was removed by the editor as SPAM

  • January 19, 2017 at 10:44 pm

    #1923927

    JasonClark - Thursday, January 19, 2017 10:20 PM

    WhiteLotus - Wednesday, January 18, 2017 5:06 PM

    Thanks for the reply guys . really appreciate it !
    Anyone knows how to get the license cost information ?

    Here you may get all the details related to cost: https://www.microsoft.com/en-us/sql-server/sql-server-2016-pricing.

    You may have a look here for knowing new features added in SQL Server 2016: http://www.sqlserverlogexplorer.com/7-new-features-for-dba/

    thanks mate , that's very helpful !

  • January 22, 2017 at 5:32 pm

    #1924284

    By the way... when you buy sql license which value that you look at in order to determine the number of users ?

  • January 23, 2017 at 2:36 am

    #1924330

    WhiteLotus - Sunday, January 22, 2017 5:32 PM

    By the way... when you buy sql license which value that you look at in order to determine the number of users ?

    For server + cal licensing?
    If licensing users, total number of people accessing the server (directly or via something like a web server)
    Licensing devices is different, speak to your MS rep.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 24, 2017 at 6:00 pm

    #1924771

    GilaMonster - Monday, January 23, 2017 2:36 AM

    WhiteLotus - Sunday, January 22, 2017 5:32 PM

    By the way... when you buy sql license which value that you look at in order to determine the number of users ?

    For server + cal licensing?
    If licensing users, total number of people accessing the server (directly or via something like a web server)
    Licensing devices is different, speak to your MS rep.

    Thanks for the reply 🙂
    I just found out that we have SA for all servers so we will upgrade for free 🙂

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply