Disabling Microsoft SQL Server resource governor for your RDS for SQL Server instance - Amazon Relational Database Service
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Disabling Microsoft SQL Server resource governor for your RDS for SQL Server instance

When you disable resource governor on RDS for SQL Server, the service stops managing workload resources. Before you disable resource governor, review how this affects your database connections and configurations.

Disabling resource governor has the following results:

  • The classifier function isn't executed when a new connection is opened.

  • New connections are automatically classified into the default workload group.

  • All existing workload group and resource pool settings are reset to their default values.

  • No events are fired when limits are reached.

  • Resource governor configuration changes can be made, but the changes don't take effect until resource governor is enabled.

To disable resource governor, remove the RESOURCE_GOVERNOR option from its option group.

The following procedure removes the RESOURCE_GOVERNOR option.

To remove the RESOURCE_GOVERNOR option from its option group

  1. Sign in to the Amazon Web Services Management Console and open the Amazon RDS console at https://console.amazonaws.cn/rds/.

  2. In the navigation pane, choose Option groups.

  3. Choose the option group with the RESOURCE_GOVERNOR option (resource-governor-ee-2022 in the previous examples).

  4. Choose Delete option.

  5. Under Deletion options, choose RESOURCE_GOVERNOR for Options to delete.

  6. Under Apply immediately, choose Yes to delete the option immediately, or No to delete it during the next maintenance window.

  7. Choose Delete.

The following procedure removes the RESOURCE_GOVERNOR option.

To remove the RESOURCE_GOVERNOR option from its option group

  • Run one of the following commands.

    For Linux, macOS, or Unix:

    aws rds remove-option-from-option-group \
    --option-group-name resource-governor-ee-2022 \
    --options RESOURCE_GOVERNOR \
    --apply-immediately

    For Windows:

    aws rds remove-option-from-option-group ^
    --option-group-name resource-governor-ee-2022 ^
    --options RESOURCE_GOVERNOR ^
    --apply-immediately