ApsaraDB RDS for SQL Server supports the dedicated instance family, general-purpose instance family, and shared instance family. This topic describes the features that are supported by each instance family of ApsaraDB RDS for SQL Server.

Primary ApsaraDB RDS for SQL Server instances

Note
  • The following content applies to ApsaraDB RDS for SQL Server instances that run Standard Edition, Enterprise Edition, and Web Edition.
  • RDS instances that run SQL Server with standard or enhanced SSDs (ESSDs) are deployed on Elastic Compute Service (ECS) instances. Performance of each RDS instance varies based on the instance family that each RDS instance uses. For more information, see Instance family.
  • For more information about instance types, see Primary ApsaraDB RDS for SQL Server instance types.
Category Feature Dedicated instance family General-purpose instance family Shared instance family
Data migration Data migration Supported Supported Supported
Instance management Instance creation Supported Supported Supported
Specification change Supported Supported Supported
Migration across zones
Note Your RDS instance must run SQL Server 2008 R2 with local SSDs.
Unsupported Unsupported Unsupported
Workload switchover between primary and secondary RDS instances Supported Supported Supported
Instance restart Supported Supported Supported
Maintenance window setting Supported Supported Supported
Instance release Supported Supported Supported
Manage ApsaraDB RDS for SQL Server instances in the recycle bin Supported Supported Supported
DBCC Supported Supported Supported
Account management Account creation Supported Supported Supported
Password reset Supported Supported Supported
Account permission modification Supported Supported Supported
Service account authorization
Note Your RDS instance must run SQL Server 2008 R2 with local SSDs.
Supported Unsupported Unsupported
Account deletion Supported Supported Supported
Database management Database creation Supported Supported Supported
Database deletion Supported Supported Supported
Database replication Supported Supported Supported
Database connection Instance connection Supported Supported Supported
Endpoint setting Supported Supported Supported
Endpoint and port number viewing Supported Supported Supported
Switch an ApsaraDB RDS for SQL Server instance to a different vSwitch Supported Supported Supported
Public endpoint application Supported Supported Supported
Monitoring and alerting Metric viewing Supported Supported Supported
Monitoring frequency setting Supported Supported Supported
Alert rule setting Supported Supported Supported
Read-only instance and read/write splitting
Note Your primary RDS instance must run SQL Server 2017 EE or 2019 EE.
Read-only instance creation Supported Supported Unsupported
Read/write splitting Supported Supported Unsupported
Read weight modification Supported Supported Unsupported
Configure the read attribute for a secondary RDS instance of a primary ApsaraDB RDS for SQL Server instance Supported Supported Unsupported
Security management Whitelist setting Supported Supported Supported
SSL encryption setting Supported Supported Supported
Transparent data encryption (TDE) setting Supported
  • SQL Server 2012 EE Basic: supported
  • SQL Server SE on RDS High-availability Edition: unsupported
Supported
Distributed transaction whitelist setting
Note Your RDS instance must run High-availability Edition.
Supported Supported Supported
Disk encryption Supported Supported Unsupported
Connect an ApsaraDB RDS for SQL Server instance to a self-managed domain Supported Supported Unsupported
Audit SQL Audit Supported Supported Supported
log management Supported Supported Supported
Event history Supported Supported Supported
Backup Data backup Supported Supported Supported
Enable the snapshot backup feature for an ApsaraDB RDS for SQL Server instance Supported Supported Supported
Enable cross-region backups for an ApsaraDB RDS for SQL Server instance Supported Supported Supported
Free quota for backup storage Supported Supported Supported
Backup file download Supported Supported Supported
Restoration Data restoration Supported Supported Supported
Diagnostics and optimization CloudDBA Supported Supported Supported
Tag management Create tags Supported Supported Supported
Delete tags Supported Supported Supported
Use tags to filter ApsaraDB RDS for SQL Server instances Supported Supported Supported