This topic describes how to reconfigure parameters and view the parameter reconfiguration history for an RDS for SQL Server instance in the RDS console.

Note In 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 RDS console.
  2. In the upper-left corner, select the region where the target RDS instance is located.
    选择地域
  3. Find the target RDS instance and click the instance ID.
  4. In the left-side navigation pane, click Parameters.
  5. On the Modifiable Parameters tab, reconfigure one or more parameters as needed.
    • To reconfigure only one parameter of the RDS instance, follow these steps:

      1. Find the parameter you want to reconfigure, and in the Actual Value column click 编辑图标.
      2. In the displayed dialog box, enter a new value within the value range and click Confirm.
      3. In the upper-right corner, click Apply Parameters.
      4. In the displayed dialog box, click Confirm.

      提交参数变更
    • To reconfigure more than one parameter of the RDS instance, follow these steps:

      1. In the upper-right corner, click Export Parameters to export the parameters as a file to your computer.
      2. Open the parameter file on your computer and reconfigure the parameters.
      3. In the upper-right corner, click Import Parameters.
      4. Copy the parameters and their values from the parameter file and paste them to the Import Parameters dialog box, then click OK.
      5. Verify the parameter values, and click Apply Changes.

      导入参数

View the parameter reconfiguration history

  1. Log on to the RDS console.
  2. In the upper-left corner, select the region where the target RDS instance is located.
    选择地域
  3. Find the target RDS instance and click the instance ID.
  4. In the left-side navigation pane, click Parameters.
  5. Click the Modification History tab.
  6. Select a time range and click Search.

APIs

Parameter reference

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