...
| Configuration ID | Since | Default | Unit | Description |
|---|---|---|---|---|
| maintenance.transaction_log_size_limit.percent | 9.8.6 | 75 | % | If the Transaction Log size exceeds the configured percentage of its maximum size, then the Maintenance Job will stop. |
| maintenance.transaction_log_size_limit.mb | 9.8.6 | 0 | MB | If greater than zero, then overrides the "maintenance.transaction_log_size_limit.percent" configuration with a fixed size. |
| maintenance.index_rebuild.min_fragmentation | 5 | % | Only those indexes will be rebuilt that are more fragmented than the specified value. | |
| maintenance.index_rebuild.min_page_count | 2000 | Only those indexes will be rebuilt that contain at least the specified number of pages. | ||
| maintenance.index_rebuild.rebuild_min_fragmentation | 30 | % | The indexes that are less fragmented than the specified value will be reorganized instead of rebuilt. | |
| maintenance.index_rebuild.wait_after_every_x_seconds | 9.8.6 | 3600 | seconds | The job will be paused every X seconds to ensure that the transaction log backup works seamlessly. |
| maintenance.index_rebuild.wait_seconds | 9.8.6 | 900 | seconds | Defines how long the job will be paused after every "maintenance.index_rebuild.wait_after_every_x_seconds". |
...