SQL Maintenance and Diagnostic
Quick Description | This automation policy reports on the condition of SQL databases as well as rebuilding and reorganizing indexes for the target database. |
Applies To | N-central 9.5.x |
Last Revised | April 10, 2014 |
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.