In some cases, when a server is upgraded to a newer version, QP metrics may be useful for comparing performance. To identify queries that may have some degradation, after a server-version upgrade:
Back up the QP metrics from the old server into a backup group:
sp_metrics ‘backup’, ’@gid’
Enable QP metrics on the new server:
sp_configure “enable metrics capture”, 1
Compare QP metrics output from the old and new servers to identify any queries that may have regression problems.
