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.
CategoryFeatureDedicated instance familyGeneral-purpose instance familyShared instance family
Data migrationData migrationSupportedSupportedSupported
Instance managementInstance creationSupportedSupportedSupported
Specification changeSupportedSupportedSupported
Migration across zones
Note Your RDS instance must run SQL Server 2008 R2 with local SSDs.
UnsupportedUnsupportedUnsupported
Workload switchover between primary and secondary RDS instancesSupportedSupportedSupported
Instance restartSupportedSupportedSupported
Maintenance window settingSupportedSupportedSupported
Instance releaseSupportedSupportedSupported
Manage ApsaraDB RDS for SQL Server instances in the recycle binSupportedSupportedSupported
DBCCSupportedSupportedSupported
Account managementAccount creationSupportedSupportedSupported
Password resetSupportedSupportedSupported
Account permission modificationSupportedSupportedSupported
Service account authorization
Note Your RDS instance must run SQL Server 2008 R2 with local SSDs.
SupportedUnsupportedUnsupported
Account deletionSupportedSupportedSupported
Database managementDatabase creationSupportedSupportedSupported
Database deletionSupportedSupportedSupported
Database replicationSupportedSupportedSupported
Database connectionInstance connectionSupportedSupportedSupported
Endpoint settingSupportedSupportedSupported
Endpoint and port number viewingSupportedSupportedSupported
Switch an ApsaraDB RDS for SQL Server instance to a different vSwitchSupportedSupportedSupported
Public endpoint applicationSupportedSupportedSupported
Monitoring and alertingMetric viewingSupportedSupportedSupported
Monitoring frequency settingSupportedSupportedSupported
Alert rule settingSupportedSupportedSupported
Read-only instance and read/write splitting
Note Your primary RDS instance must run SQL Server 2017 EE or 2019 EE.
Read-only instance creationSupportedSupportedUnsupported
Read/write splittingSupportedSupportedUnsupported
Read weight modificationSupportedSupportedUnsupported
Configure the read attribute for a secondary RDS instance of a primary ApsaraDB RDS for SQL Server instanceSupportedSupportedUnsupported
Security managementWhitelist settingSupportedSupportedSupported
SSL encryption settingSupportedSupportedSupported
Transparent data encryption (TDE) settingSupported
  • 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.
SupportedSupportedSupported
Disk encryptionSupportedSupportedUnsupported
Connect an ApsaraDB RDS for SQL Server instance to a self-managed domainSupportedSupportedUnsupported
AuditSQL AuditSupportedSupportedSupported
log managementSupportedSupportedSupported
Event historySupportedSupportedSupported
BackupData backupSupportedSupportedSupported
Enable the snapshot backup feature for an ApsaraDB RDS for SQL Server instanceSupportedSupportedSupported
Enable the cross-region backup feature for an ApsaraDB RDS for SQL Server instanceSupportedSupportedSupported
Free quota for backup storageSupportedSupportedSupported
Backup file downloadSupportedSupportedSupported
RestorationData restorationSupportedSupportedSupported
Diagnostics and optimizationDASSupportedSupportedSupported
Tag managementCreate tagsSupportedSupportedSupported
Remove tags from an ApsaraDB RDS for SQL Server instanceSupportedSupportedSupported
Use tags to filter ApsaraDB RDS for SQL Server instancesSupportedSupportedSupported