Post reply

SQL 2014 is running slower than SQL 2008

  • June 10, 2015 at 8:16 am

    #1804357

    Am I reading this correctly that you are concerned about 1/4th of a second runtime for a query? 1000 milliseconds is 1 second.

    It could be a ton of things really. The first thing to rule out is doing an explain plan on the old system and new system to see what the newly rewritten optimizer is using for indexes and execution plan versus the old system.

  • June 10, 2015 at 8:32 am

    #1804362

    luis_carlosh (6/9/2015)

    Steps I done:

    OLD SQL 2008> task > backup DB

    NEW SQL 2014 task > Restore DB

    1) SET COMPATIBILITY_LEVEL = 120

    2) REBUILD ALL INDEXES

    3) EXEC sp_updatestats

    Any way the miliseconds in simple 'select' are the same than before...

    OLD SQL 2008> task > backup DB

    NEW SQL 2014 task > Restore DB

    1) SET COMPATIBILITY_LEVEL = 120

    2) REBUILD ALL INDEXES << Good

    3) EXEC sp_updatestats << Possibly bad as the rebuild above updated statistics with 100% scan, this probably sampled

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

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