Why an Upgrade can Cause Performance Regressions (Dear SQL DBA Episode 9)
Category:
query-performance
, database-administration
You finally got approval to move to new hardware and a fresher version of SQL Server. After months of work, you do the migration and then… performance gets worse. What can cause this, and what do you look for?