I recently had to migrate a database from SQL Server 2008 Express to SQL Server 2017 Express and one of the stored procedures started suffering a very significant performance impact. The profiler shows that on SQL Server 2008 this stored procedure performs 1370 reads and takes 59ms to execute, while on SQL Server 2017 this exact stored procedure performs 127256 reads and takes 6931ms to execute. The database was migrated through the binary backup/restore function. What can be causing such a massive performance degradation?
You need to sign in to view this answers
