Reconfigure the parameters of an ApsaraDB RDS for SQL Server instance by using the ApsaraDB RDS console

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. 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