> Automation > Policies > Sytem Management > SQL Maintenance and Diagnostic

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 will report 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 required.

Automation Policy

Outcome

This Automation Policy can be used to capture detailed SQL database diagnostics as well as running maintenance operations on database tables.