Analyzing SQL Indexes through the Command Line

You can automate index mamahement using the command line.

  1. Click Start, type ‘cmd’ in the Search programs and files text box, and press ENTER. The Command Prompt opens.
  2. Specify the operation you want to perform and the required parameters and arguments (actions you want to run) in the Command Prompt, for example as follows:
    indexmanagersql.com /analyzeindex [/switch1[:value | [parameter1:value parameter2:value ..]] /switch2 ..]
    
  3. Press ENTER to run the process.

Select corresponding command line switches to perform the required operations:

Argument Action and Usage
/connection This switch is used to specify a connection string. The command line looks like: connection: connection_string
/database This switch is used to specify a database to manage indexes in. The command line looks like: database: value
/minindexsize This switch is used to specify the minimum index size in pages. Overrides global option. The command line looks like: minindexsize: value
/password This switch is used to specify a password. Overrides password specified in the connection string. The command line looks like: password: pw
/rebuildthreshold Specifies rebuild the fragmentation threshold in %. Overrides global option. The command line looks like: rebuildthreshold: value
/reorganizethreshold Specifies reorganize the fragmentation threshold in %. Overrides global option. The command line looks like: reorganizethreshold: value
/tempdbsort This switch is used to override the “Sort in tempdb” global option. The command line looks like: tempdbsort: on/off