search

olahallengren / sql-server-maintenance-solution

SQL Server Maintenance Solution
https://ola.hallengren.com
MIT License
2.91k stars 756 forks source link

Index maintenance : Skip filegroup / partition #785

Open mvendramin opened 11 months ago

mvendramin commented 11 months ago

I have a huge DB, partitioned by year, and some cleaning process remove monthly data older than retention period ( 10 years ) I free up some space shrinking old filegroups data files ( related to partition ) , but as reorg runs again it allocates a lot of new space because of index fragmentation generated by shrink.

I would like to skip index maintenance in old partitions, actually there's no way to do that

Is it possible to add a parameter to exclude some partitions in index maintenance procedure ?

mvendramin commented 11 months ago

The same request was done by [JSpence44202] on Sept, 27