• Relational Database Service

rds
  1. Help Center
  2. Relational Database Service
  3. User Guide
  4. Working with RDS for Microsoft SQL Server
  5. Modifying Parameters in a Parameter Group

Modifying Parameters in a Parameter Group

This section describes how to modify parameters in custom parameter groups.

NOTE:

RDS includes default parameter groups that cannot be modified. You can view them by clicking their names. If a custom parameter group is set incorrectly and causes a database reboot to fail, you can use a default parameter group to reset the database.

Modifying Parameters in a Parameter Group

  1. Logging in to the management console
  2. Click in the upper left corner and select a region and a project.
  3. Click Service List. Under Database, click Relational Database Service to go to the RDS console.
  4. On the Parameter Group Management page, click the target parameter group.
  5. Modify the parameters as required.

    Relevant parameters are as follows:

    • For details on parameter descriptions, visit the Microsoft SQL Server official website.
    • Set remote access to 0 (default value) to prevent locally stored procedures from running on a remote server and remotely stored procedures from running on a local server.
    • max server memory (MB) indicates the server memory. Its default value is equal to the OS memory (MB) minus 520 MB. Its minimum value is 16.

    Available operations are as follows:

    The modifications take effect only after you apply the parameter group to target DB instances. For details, see section Applying a Parameter Group to DB Instances.

    • To save the modifications, click Save.
    • To cancel the modifications, click Cancel.
    • To preview the modifications, click Preview.

    After the parameter values are modified, you can click View Change History to view the modification details.

    NOTE:

    For details about the parameter group statuses, see DB Instance Statuses.

    For details about the parameter group statuses, see the parameter group statuses in the "DB Instance Statuses" section in the Relational Database Service Product Introduction.

Modifying Parameters of a Specified DB Instance

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click Service List. Under Database, click Relational Database Service to go to the RDS console.
  4. On the Instance Management page, click the target DB instance.
  5. On the Parameters page, modify the parameters as required.

    Relevant parameters are as follows:
    • For details on parameter descriptions, visit the Microsoft SQL Server official website.
    • Set remote access to 0 (default value) to prevent locally stored procedures from running on a remote server and remotely stored procedures from running on a local server.
    • max server memory (MB) indicates the server memory. Its default value is equal to the OS memory (MB) minus 520 MB. Its minimum value is 16.

    Available operations are as follows:

    After you modify parameters in a parameter group, the modifications immediately take effect for the DB instances to which the parameter group applies.

    For details about the parameter group statuses, see Parameter Group Statuses.

    After you modify parameters in a parameter group, you need to view the statuses of the DB instances to which the parameter group applies. If the status is Pending reboot, you must reboot the DB instance for the modifications to take effect.

    Rebooting is always required after modifying parameters in a parameter group under the following circumstances:

    • The modified parameter group is applied to primary/standby DB instances. In this case, the standby DB instance will also be changed accordingly after the reboot.
    • The modified parameter group is applied to read replicas.
    • To save the modifications, click Save.
    • To cancel the modifications, click Cancel.
    • To preview the modifications, click Preview.

    After the parameter values are modified, you can click View Change History to view the modification details.