Share via

Performance degrade after migrating to SQL server 2022

Ginesh 0 Reputation points
2025-08-27T13:56:31.7266667+00:00

Application performance degraded by 15-20 % after moving the database from SQL server 2019 to 2022 on a stand alone server. The resources and maintenance remains the same as the 2019.

SQL Server Database Engine

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 124.9K Reputation points MVP Volunteer Moderator
    2025-08-27T21:28:12.16+00:00

    I would recommend that you revert to 150 to see if the degradation persists. If it does not, the degradation is due to one or more queries seeing performance regressions with the new features of the optimizer.

    Keep running with compat level 150 for a week or two and then flip back to 160. You can now use Query Store to find the degraded queries, and as a quick resolution you can force the old plans from compat level 150. In the long run, you may want to take a closer look at these queries to see how they can be improved.

    While you can do this check manually, there is also a tool in SSMS to help you. Right-click the database in SSMS and select Tasks. You find Database Upgrade at the bottom of the menu.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.