If non-zero, this provides the goal for filling pages, specified as a percentage between 1 and 100. Any page not at or above this percentage full will be considered for compaction. The default behavior is to consider every page for compaction, regardless of its page fill percentage.

If non-zero, compaction will complete after the specified number of pages have been freed.

If non-zero, and no Transaction is specified, this parameter identifies the lock timeout used for implicit transactions, in microseconds.