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

Prerequisites

The instance runs SQL Server 2008 R2 with local SSDs.

Precautions

  • For instance stability purposes, you are allowed to reconfigure only some parameters in the ApsaraDB for RDS console. If you want to modify more parameters, submit a ticket.
  • When you reconfigure parameters on the Editable Parameters tab, refer to the Value Range column that corresponds to each parameter.
  • After you modify certain parameters, you must restart your RDS instance for the changes to take effect. For more information, refer to the Force Restart column on the Editable Parameters tab. 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.
  • If your RDS instance runs SQL Server 2012 or later, you can reconfigure parameters only by using SQL commands. For more information, see Reconfigure parameters by using SQL commands.

Reconfigure parameters

  1. Log on to the ApsaraDB for RDS console.
  2. In the top navigation bar, select the region where the target RDS instance resides.
    Select a region
  3. Find the target RDS instance and click its ID.
  4. In the left-side navigation pane, click Parameters.
  5. On the Editable Parameters tab, reconfigure one or more parameters.
    • To reconfigure a single parameter, follow these steps:
      1. Find the parameter and in the Actual Value column click .
      2. In the dialog box that appears, enter a new value within the value range and click Confirm.
      3. In the upper-right corner, click Apply Changes. In the dialog box that appears, click Confirm.
    • To reconfigure more than one parameter at a time, follow these steps:
      1. In the upper-right corner, click Export Parameters to download the parameters and their values as a file to your computer.
      2. Open the file and reconfigure parameters.
      3. In the upper-right corner, 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. Log on to the ApsaraDB for RDS console.
  2. In the top navigation bar, select the region where the target RDS instance resides.
    Select a region
  3. Find the target RDS instance and click its ID.
  4. In the left-side navigation pane, select Parameters.
  5. Click the Edit History tab.
  6. Select a time range and click Search.

Parameter

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

Related operations

Operation Description
ModifyParameter Reconfigures the parameters of an ApsaraDB for RDS instance.
DescribeParameterTemplates Queries the parameter templates available to use for an RDS edition with a specific version of database engine.
DescribeParameters Queries the parameter settings of an ApsaraDB for RDS instance.