You can perform a manual defragmentation using the command line utility sqldefragc. This utility is included with the SQL Defrag Manager installation. 

Note: You need to run the command line console as an Administrator.

sqldefragc [[[–rebuild [online]] | –reorg] –instance <instance name> –database <database name> | –policy <policy name>]


There are two ways to use sqldefragc

  1. Specify rebuild or reorg where online is optional for rebuild, specify the instance name, and specify the database name.

    sqldefragc [[–rebuild [online]] | –reorg] –instance <instance name> –database <database name>
  2. Define the defragmentation based on an existing policy by specifying the policy name.

    sqldefragc –policy <policy name>



SQL Defrag Manager find and fix SQL fragmentation hot spots fast.
IDERAProductsPurchase | Support | Community | Resources | About Us | Legal




  • No labels