SQL Server 2016 → 2022 post-migration scripts

Companion SQL package for the Compat 160 performance playbook. Prefer the interactive guide for guided remediation.

Open Compat 160 interactive playbook

Open playbook from this package folder

Handbook article on sqloptima

Folders

01_Diagnostics/ — baselines, waits, plan compare
02_Configuration/ — instance/DB/TempDB settings
03_QueryStore_PlanForce/ — enable QS, regressions, force plans
04_Statistics_Indexes/ — stats and index health
05_Compatibility_CE_Controls/ — CE/IQP controls and cutover runbook
06_Code_Rewrite_Patterns/ — before/after T-SQL patterns
07_Monitoring_Baseline/ — before/after metrics
docs/ — markdown playbooks and client checklist