SQL Integrity CheckDBAllocations

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.

Output Parameters

Name Type Description
ActionResult 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