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
View the parameter reconfiguration history
- Visit the RDS instance list, select a region above, and click the target instance ID.
- In the left-side navigation pane, click Parameters.
- Click the Edit History tab.
- 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. |