You can reconfigure the parameters of an ApsaraDB RDS for SQL Server instance by using SQL statements or the ApsaraDB RDS console. This topic describes how to reconfigure the parameters by using SQL statements.

Note The SQL statements described in this topic are supported only for RDS instances that run SQL Server 2012 or later. For information about how to reconfigure the parameters of an RDS instance that runs SQL Server 2008 R2, see Reconfigure parameters in the ApsaraDB for RDS console.

Supported parameters

  • fill factor (%)
  • max worker threads
  • cost threshold for parallelism
  • max degree of parallelism
  • min server memory (MB)
  • max server memory (MB)
  • blocked process threshold (s)

Reconfigure parameters

Use the sp_rds_configure stored procedure to specify the parameters that you want to reconfigure. If the new settings of the specified parameters take effect only after your RDS instance restarts, ApsaraDB RDS displays a message.

Example:

USE master
GO
--database engine edtion
SELECT SERVERPROPERTY('edition')
GO
--create database
CREATE DATABASE testdb
GO
SELECT * 
FROM sys.configurations
WHERE NAME = 'max degree of parallelism'
EXEC sp_rds_configure 'max degree of parallelism',0
WAITFOR DELAY '00:00:10'
SELECT * 
FROM sys.configurations
WHERE NAME = 'max degree of parallelism'