Timeline for Performance issues after moving a database to SQL Server 2014
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 1, 2017 at 10:08 | comment | added | T.H. | Ok, at this point I would be considering "manually" replacing statistics to tide me over. (Argh too long for comment, see answer I've just added.) | |
| Jan 31, 2017 at 15:00 | comment | added | Sam | I've reloaded the database back to its original state from a backup that we had, and was able to duplicate by just changing the compat level. Updating statistics will also cause a similar slowdown. The difference in the queries is a difference of 1 minute on level 100 and 12 hours on level 120 | |
| Jan 31, 2017 at 10:02 | history | edited | T.H. | CC BY-SA 3.0 |
Added update
|
| Jan 30, 2017 at 17:16 | history | answered | T.H. | CC BY-SA 3.0 |