tencent cloud

Feedback

Setting Instance Parameters

Last updated: 2022-03-29 15:24:05

    You can view and modify certain parameters and query parameter modification logs in the TencentDB for SQL Server console.

    Notes

    • To ensure instance stability, only some parameters can be modified in the console. These parameters are displayed on the Parameter Settings page.
    • If the modified parameter requires instance restart to take effect, the system will ask you if you wish to restart. We recommend you do so during off-peak hours and ensure that your application has a reconnection mechanism.

    Batch Modifying Parameters

    1. Log in to the TencentDB for SQL Server console. In the instance list, click an instance ID or Manage in the Operation column to access the instance management page.
    2. On the instance management page, select the Parameter Configuration > Parameter Settings tab and click Batch Modify Parameters.
    3. Select the target parameters and modify their values in the Current Value column. After confirming that everything is correct, click OK.
    4. In the pop-up window, select the Execution Mode and click OK.
      Note:

      • If you select Immediate execution, the parameter modification task will be executed and take effect immediately.
      • If you select During maintenance time, the parameter modification task will be executed and take effect during the instance maintenance time.

    Modifying One Parameter

    1. Log in to the TencentDB for SQL Server console. In the instance list, click an instance ID to access the instance management page.
    2. On the instance management page, select the Parameter Configuration > Parameter Settings tab, select the row of the target parameter, and click img in the Current Value column to modify its value.
    3. Enter the target parameter value as prompted in the Current Value column and click img to save the change. You can click img to cancel the operation.
    4. In the pop-up window, select the Execution Mode and click OK.
      Note:

      • If you select Immediate execution, the parameter modification task will be executed and take effect immediately.
      • If you select During maintenance time, the parameter modification task will be executed and take effect during the instance maintenance time.
    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support