SQL Maintenance and Diagnostic
Overview
This automation policy reports SQL database defragmentation statistics including the integrity of the catalog, the integrity of the database, and the average fragmentation of the indexes. It will also rebuild and reorganize the indexes for the target SQL database.
Input parameters
No input parameters are required.
Automation policy
Outcome
The policy captures detailed SQL database diagnostics as well as running maintenance operations on database tables.