statistics : will run only statistics update
index : will run only index maintenance
smart : will touch only modified statistics and choose index maintenance by % of fragmentation
dummy : will run through all statistics or indexes.
0 : this feature is off.
1 : will log the operation to table [AzureSQLMaintenanceLog] (if the table does not exist it will be created automatically) the log will update ongoing with any progress so you can monitor the progress with this log. for every operation, you can find detailed information about the object before it was maintained (fragmentation percent for indexes, and modification counter for statistics) by default only 3 last operations will be kept in the log table, older execution log will be automatically removed, this can be changed in the procedure code.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.