Enable Auto-Indexing in SQL Server Management Studio

After you have completed deployment of your Azure deployment of PMC, auto-indexing needs to be enabled. This is accomplished by using SQL Server Management Studio to update the Auto Index setting of the System Parameters table in the Management Database.

  1. Open the Azure Portal and navigate to your Resource Group.
  2. From the resource group, select the Avecto.IC3.Databases.Management SQL database.

Copy the server name. You will need it in the next step.

  1. Select the Server name from this menu and copy it.


  1. Open Microsoft SQL Server Management Studio and enter the server name you copied into the Server name field.
  2. Log in using the SQL admin credentials that were specified in the installation script.
  3. Open the Avecto.IC3.Databases.Management database and expand Tables.
  4. Right-click the dbo.SystemParameter table and select Edit Top 200 Rows.
  5. Locate AutoIndexMaintenaceEnabled in the ParameterName column and change its value from 0 to 1 to enable auto-indexing.

For more information about the SQL admin credentials that are specified during installation, please see Deploy Privilege Management Console.