This topic provides an overview of the features supported by ApsaraDB RDS instances that run SQL Server 2016. In the following table, ticks (️✔️) indicate that a feature is supported, and crosses (❌) indicate that a feature is not supported.

Category Feature SQL Server 2016 EE SQL Server 2016 SE SQL Server 2019 Web
RDS High-availability Edition RDS Basic Edition RDS High-availability Edition RDS Basic Edition
Standard SSD ESSD of PL1, ESSD of PL2, or ESSD of PL3 Standard SSD ESSD Standard SSD ESSD of PL1, ESSD of PL2, or ESSD of PL3 Standard SSD ESSD
Data migration Migrate the data of an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Instance management Create an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Change the specifications of an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Migrate an ApsaraDB RDS for SQL Server instance across zones in the same region ❌ ❌ ❌ ❌ ❌ ❌ ❌ ❌
Switch workloads over between primary and secondary ApsaraDB RDS for SQL Server instances ✔️ ✔️ ❌ ❌ ✔️ ✔️ ❌ ❌
Restart an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Set the maintenance window of an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Release an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Manage ApsaraDB RDS for SQL Server instances in the recycle bin ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Use DBCC statements on an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Instance upgrade Upgrade the RDS edition of an ApsaraDB RDS for SQL Server instance from Basic Edition to High-availability Edition ❌ ❌ ✔️ ✔️ ❌ ❌ ✔️ ✔️
Account management Create an account on an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Reset the password of an account of an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Modify the permissions of an account of an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Grant permissions to the service account of an ApsaraDB RDS for SQL Server instance ❌ ❌ ❌ ❌ ❌ ❌ ❌ ❌
Delete an account from an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Database management Create a database on an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Delete a database from an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Replicate a database from an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Database connection Connect to an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Configure endpoints for an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
View and change the internal and public endpoints and port numbers of an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Switch an ApsaraDB RDS for SQL Server instance to a different vSwitch ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Apply for a public endpoint for an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Monitoring and alerting View the resource metrics, engine metrics, and deployment metrics of an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Set the monitoring frequency of an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Configure an alert rule for an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Read-only instance and read/write splitting Create a read-only ApsaraDB RDS for SQL Server instance ❌ ❌ ❌ ❌ ❌ ❌ ❌ ❌
Enable the read/write splitting feature for an ApsaraDB RDS for SQL Server instance ❌ ❌ ❌ ❌ ❌ ❌ ❌ ❌
Modify the read weights of read-only ApsaraDB RDS for SQL Server instances ❌ ❌ ❌ ❌ ❌ ❌ ❌ ❌
Security management Configure an IP address whitelist for an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Configure SSL encryption for an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Configure TDE for an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ❌ ❌ ❌ ❌
Configure a distributed transaction whitelist for an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ❌ ❌ ✔️ ✔️ ❌ ❌
Configure disk encryption for an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Audit Use the SQL Audit feature on an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Manage the logs of an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
View the event history of an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Backup Back up an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Enable snapshot backups for an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Enable cross-region backups for an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Provide a free quota for backup storage for an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Download the backup files of an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Restoration Restore the data of an ApsaraDB RDS for SQL Server instance ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Diagnosis and optimization Introduction to CloudDBA in ApsaraDB RDS for SQL Server ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Tag management Create tags ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Delete tags ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️
Use tags to filter ApsaraDB RDS for SQL Server instances ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️ ✔️