tigertoolbox icon indicating copy to clipboard operation
tigertoolbox copied to clipboard

Defrag all partitions one by one + brackets

Open glienard opened this issue 4 years ago • 1 comments

In the original version you have either the option to defrag only the right partition or all but the right one, which is good for sliding window partitions, or defrag all partitions at the same time. I added a 4th option to defrag partitions partition by partition when needed. Instead of doing all partitions it will go over each partition - including the right one - and will defrag them if needed.

Use @dealMaxPartition tinyint = 2 /* 0 = only right-most partition; 1 = exclude right-most populated partition; 2=look at all partitions; NULL = do not exclude; see notes for caveats; only in Enterprise Edition */

Note that I have also included the pull request of https://github.com/microsoft/tigertoolbox/pull/258 as I encountered the same problems

glienard avatar Dec 05 '21 11:12 glienard

CLA assistant check
All CLA requirements met.

ghost avatar Dec 05 '21 11:12 ghost