SQL Database Defragmentation Levels

This Automation Manager object returns the average fragmentation of the indexes of an SQL server.

Privileges

Normal

Input Parameters

Name Type Required Description
SQL Server String Yes The name of the instance of an SQL server.
Database Name String Yes The name of the database in an SQL server.
Table Name String No The name of the table in the database of an SQL server.

Output Parameters

Name Type Description
IndexDefragList String collection

Returns a list of that contains the following members:

  • Table Name
  • Index Name
  • Fragmentation
Result Number

Returns a success value of zero or any value other than zero to indicate failure.

Example Input Parameters

Name Type Required Example
SQL Server String Yes localhost
Database Name String Yes SQLdev
Table Name String No <intentionally left blank>