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.