Modifying Parameters of RDS for SQL Server Instances

You can modify parameters in custom parameter templates.

Each DB instance is assigned with a group of parameters when it is being created and modifications to these parameters do not affect other DB instances.

Procedure

Log in to the management console.
Click in the upper left corner and select a region.
Click in the upper left corner of the page and choose Databases > Relational Database Service.
On the Instances page, click the target DB instance.

On the Parameters page, modify the parameters as required.

You cannot modify parameters in a default parameter template.
- Each Microsoft SQL Server version has a unique default parameter template.
- To apply a default parameter template to the current DB instance, choose Parameter Templates page in the navigation pane on the left, locate the target template on the Default Templates page, and click Apply in the Operation column.
You can modify parameters in a custom template.
- To create a custom template, choose Parameter Templates page in the navigation pane on the left, click Create Parameter Template on the Custom Templates page, and configure required information in the displayed dialog box. Then, click OK.
- After you save modifications to the parameters in the custom template, you can apply this parameter template to multiple DB instances running corresponding versions.

You can modify the parameters listed in Table 1 to improve DB instance performance.

**Table 1** Parameters
Parameter	Description	Application Scenario
max degree of parallelism	Specifies the maximum degree of parallelism option. When an RDS for SQL Server DB instance runs on a computer with more than one microprocessor or CPU, RDS for SQL Server detects the best degree of parallelism (the number of processors used to run a single statement) for each parallel plan execution. The default value is 0.	If the DB instance is used for querying results, set the parameter to 0. If the DB instance is used for operations such as inserting, updating, and deleting, set the parameter to 1.
max server memory (MB)	Specifies the server memory option. It is used to reconfigure the amount of memory (in MB) in the buffer pool used by a Microsoft SQL Server DB instance.	You are advised to retain the default value for this parameter. If you want to modify this parameter, the value of this parameter must be: No less than 2 GB. Not greater than 95% of the maximum memory of the DB instance.
user connections	Specifies the maximum number of simultaneous user connections allowed on Microsoft SQL Server. Default value: 1000	If this parameter is set to 0, the number of connections to the DB instance is not limited. Allowed values: Values excluding 1 to 10