Queries are running slower after migrating?
There’s a solution for everything. If your queries are running slower after migrating, you can use the Query Store to force lower compatibility plans. The query store is a very easy way to track the queries happening in your database, with pre made charts and filters, queries can be aggregated on cpu, reads, execution count, …. You can also force query plans, so a query always uses a certain plan. We will be using the force query plan further down this blog post.