olahallengren
Index Maintenance performance for incremental stats
Still slow processing in databases with a lot of partitions. Could the code from previous ticket be implemented in regular official release? https://github.com/olahallengren/sql-server-maintenance-solution/issues/146
Running in the same way on SQL 2016-2022
Latest download 7/23 from github with support for SQL 2025
EXECUTE [dbo].[IndexOptimize] @Databases = 'DB', @LogToTable = 'Y', @SortInTempdb='Y', @FragmentationLow = NULL, @FragmentationMedium = NULL, @FragmentationHigh = NULL, @OnlyModifiedStatistics='Y', @UpdateStatistics='ALL', @PartitionLevel='Y', @execute='n'
No output for the longest time. In my lab db the output of what stats to process started populating after ~30m and further output of what should be processed was also slow. After ~45m in 1/4 was done, where as the /146 code fix version finished it all in 15m.
Was thinking it would be a good time to bring this up since there's quite a bit of work being done now for the oncoming SQL 2025.
