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 |
| 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 the cross-region backup feature 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 | DAS | Supported | Supported | Supported |
Tag management | Create tags | Supported | Supported | Supported |
Remove tags from an ApsaraDB RDS for SQL Server instance | Supported | Supported | Supported | |
Use tags to filter ApsaraDB RDS for SQL Server instances | Supported | Supported | Supported |