This topic describes how to view and reconfigure some parameters of an ApsaraDB RDS for SQL Server instance by using the ApsaraDB RDS console or API operations. You can also query the parameter reconfiguration history.

Prerequisites

Your RDS instance runs SQL Server 2008 R2 with local SSDs.

Precautions

  • After you reconfigure some parameters, your RDS instance restarts when you click Apply Changes. For more information, check the Force Restart column on the Editable Parameters tab in the ApsaraDB RDS console. We recommend that you reconfigure these parameters during off-peak hours and make sure that your application is configured to automatically reconnect to your RDS instance.
  • To ensure instance stability, the ApsaraDB RDS console allows you to reconfigure only some parameters. If you cannot find the parameter that you want to reconfigure, submit a ticket.
  • When you reconfigure parameters, you can view the valid values of these parameters in the Value Range column on the Editable Parameters tab in the ApsaraDB RDS console.
  • If your RDS instance runs SQL Server 2012 or later, you can reconfigure parameters only by using SQL statements. For more information, see Reconfigure the parameters of an ApsaraDB RDS for SQL Server instance by using SQL statements.

Reconfigure parameters

  1. Visit the RDS instance list, select a region above, and click the target instance ID.
  2. In the left-side navigation pane, click Parameters.
  3. On the Editable Parameters tab, reconfigure one or more parameters.
    • To reconfigure a single parameter, perform the following steps:
      1. Find the parameter and in the Running Parameter Value column click .
      2. In the dialog box that appears, enter a new value within the value range and click OK.
      3. Click Apply Changes. In the message that appears, click OK.
    • To reconfigure more than one parameter at a time, perform the following steps:
      1. Click Export Parameters to download the parameters and their values as a file to your computer.
      2. Open the file and reconfigure parameters.
      3. Click Import Parameters.
      4. In the Import Parameters dialog box, paste the parameters and their new values copied from the file and click OK.
      5. Verify the parameter values and click Apply Changes.

View the parameter reconfiguration history

  1. Visit the RDS instance list, select a region above, and click the target instance ID.
  2. In the left-side navigation pane, click Parameters.
  3. Click the Edit History tab.
  4. Select a time range and click OK.

Parameters

For more information, see Server Configuration Options (SQL Server).

Related operations

Operation Description
Modify parameters of an ApsaraDB for RDS instance Reconfigures the parameters of an ApsaraDB RDS instance.
Query the parameter template of an ApsaraDB for RDS instance Queries the parameter templates available to an ApsaraDB RDS instance.
Query parameter configurations Queries the parameter settings of an ApsaraDB RDS instance.