Upgrading to SQL Server 2014 R2 (SSRS related)

  • Jay@Work

    SSCrazy

    Points: 2444

    Tomorrow I plan to do an in place upgrade of a SQL Server (standard) 2008R2 instance to 2014 R2.

    Among a couple of other things this server also hosts reporting services. Is there anything I need to take into consideration regarding SSRS? Will the report server continue to run as normal? Will new/edited reports be ok?

  • Grant Fritchey

    SSC Guru

    Points: 396384

    Strongest possible consideration, completely ignoring your SSRS question, don't do it. Don't upgrade to 2014. It introduces problems without good solutions. 2016 or better is the way to go. It's because of the new cardinality estimation engine. 2016 has Query Store and DATABASE SCOPED CONFIGURATION settings that help. 2014 has nothing.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

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

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