CODEWITHSUNDEEP
sql-serverdatabase-migrationsql-server-2017cardinality-estimation
Thomas Foster
Thomas Foster

Reputation: 1

How can I test the accuracy of the the cardinality estimator when migrating between SQL Server versions?

In the near future the current the current database infrastructure is to be migrated to SQL Server 2017 from 2008R2.

Once all of the databases have been migrated to the new server I would like to upgrade the compatibility level to 140. This is to take advantage of the new features in 2017, such as the Adaptive Query Engine.

However many have warned that this will have an implications on cardinality estimators and other features.

How can I test the implications of changing the compatibility level to ensure that there has been little to no impact as a result of the change?

Upvotes: 0

Views: 76

Answers (0)

Related Questions