The client is on SQL Server 2019, which meant I had a lot of available tools to perform this analysis. The first is the Query Store , a feature introduced in SQL Server 2016 and improved in each ...

In Azure SQL Database you can also set a HISTORY_RETENTION_PERIOD (and should be able to do it in SQL Server 2017) to control how far back in time your history will extend. Converting Existing Table ...