...
Step 6 - A notification banner will appear on the top. Click on the click here link, so you will be redirected to the Configuration Tasks tab. Click on the Execute button in order to execute the changes.
Advanced Configuration
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 | 3600 | seconds | The job will be paused every X seconds to ensure that the transaction log backup works seamlessly. | |
maintenance.index_rebuild.wait_seconds | 900 | seconds | Defines how long the job will be paused after every "maintenance.index_rebuild.wait_after_every_x_seconds". |
The configuration can be changed with the pr_set_system_setting stored procedure. For example:
DECLARE
@name VARCHAR(512) = 'maintenance.transaction_log_size_limit.percent' /* TODO replace to the ID of the configuration */
, @value VARCHAR(256) = '50' /* TODO replace to the desired value */
;
EXEC pr_set_system_setting
@p_name = @name
, @p_value = @value
, @p_value_number = 1
, @p_visible = 1
, @p_value_read_only = 0
GO