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

  • To ensure instance stability, the ApsaraDB RDS console allows you to reconfigure only some parameters.
  • 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. Access RDS Instances, select a region at the top, and then click the ID of the target RDS instance.
  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. Access RDS Instances, select a region at the top, and then click the ID of the target RDS instance.
  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

OperationDescription
Modify parameters of an instanceReconfigures the parameters of an ApsaraDB RDS instance.
Query the valid values and default values of parametersQueries the parameter templates available to an ApsaraDB RDS instance.
Query parameter configurationsQueries the parameter settings of an ApsaraDB RDS instance.