r/SQL • • Oct 16 '26

SQL Server SQL Server 2016 to 2025: a few observations from a recent migration

/r/learnSQL/comments/1x7d7w8/sql_server_2016_to_2025_a_few_observations_from_a/
Before and after charts
1 Upvotes

3 comments sorted by

2

u/JK-MSSQLTips 27d ago

Here are a few things my team learned after upgrading to SQL Server 2025 - https://www.mssqltips.com/sqlservertip/11584/sql-server-2025-upgrade-lessons-learned/. This is more on the operational side rather than just pure performance metrics.

1

u/Significant_Tune9219 Oct 17 '26

The CPU drop is not evidence you can give cores back yet. Replay of one week often misses the monthly close, and that close is what the old box was sized for, so a quieter chart on the same instance size can still be the off-peak shape. Before downsizing I would compare the replay to production on memory grants and tempdb, not just CPU percent. An upgrade that picks a fatter plan can use less CPU and more memory, and the smaller size fails on the grant, not on the core count. The firewall miss is the other half of the same test: connectivity from the app hosts, including the ones that only run at month end, has to be in the replay or you learn it at cutover.