Post reply

Upgrading from SQL Server 2008 R2 to SQL Server 2016

  • December 22, 2016 at 1:45 pm

    #332920

    Hi All ,

    We have all application databases in SQL Server 2008 R2 .

    I am looking forward to upgrade the 2008 R2 databases to SQL Server 2016.

    Could you please share your experience with this upgrade .

    Is SQL Server 2016 the better option or SQL Server 2014 ?

    What are the challenges ?

    Thanks!!

  • December 23, 2016 at 2:59 am

    #1919475

    Go to 16.

    Upgrading to SQL 2014 is the same work as upgrading to 16, and leaves you with an older version, fewer features and less time before it's out of support.

    You WILL need to test the entire workload for performance problems, it's fairly easy to do with Query Store.

    Reason is that the cardinality estimator changed in SQL 2014, most queries will either stay the same or get a minor performance improvement, a small number will likely degrade in performance. You need to identify and fix those before upgrading the production server.

    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

  • December 23, 2016 at 6:38 am

    #1919514

    Thank you!

    This will definitely help. And YES we are going for 16.

    GilaMonster (12/23/2016)

    Go to 16.

    Upgrading to SQL 2014 is the same work as upgrading to 16, and leaves you with an older version, fewer features and less time before it's out of support.

    You WILL need to test the entire workload for performance problems, it's fairly easy to do with Query Store.

    Reason is that the cardinality estimator changed in SQL 2014, most queries will either stay the same or get a minor performance improvement, a small number will likely degrade in performance. You need to identify and fix those before upgrading the production server.

Viewing 3 posts - 1 through 2 (of 2 total)

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