Features supported by ApsaraDB RDS for SQL Server - ApsaraDB RDS

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

RDS SQL Server primary instance

Note

The following content applies to ApsaraDB RDS for SQL Server instances that run Standard Edition, Enterprise Edition, and Web Edition.
RDS SQL Server instances with disk storage are built on Elastic Compute Service (ECS). Different instances may use different ECS instance types, which may result in performance differences.
For more information, see Instance types for primary ApsaraDB RDS for SQL Server instances.

Category	Feature	Dedicated instance family	General-purpose instance family	Shared instance family
Data migration	Data migration	✔️	✔️	✔️
Instance management	Create an instance	✔️	✔️	✔️
	Change configurations	✔️	✔️	✔️
	Migrate across zones	✔️	✔️	❌
	Switch between primary and secondary instances	✔️	✔️	✔️
	Restart an instance	✔️	✔️	✔️
	Set the maintenance window	✔️	✔️	✔️
	Release an instance	✔️	✔️	✔️
	Recycle bin	✔️	✔️	✔️
	DBCC	✔️	✔️	✔️
Account management	Create an account	✔️	✔️	✔️
	Reset the password	✔️	✔️	✔️
	Modify account permissions	✔️	✔️	✔️
	Delete an account	✔️	✔️	✔️
Database management	Create a database	✔️	✔️	✔️
	Delete a database	✔️	✔️	✔️
	Copy a database	✔️	✔️	✔️
Database connection	Connect to an instance	✔️	✔️	✔️
	Configure connection addresses	✔️	✔️	✔️
	View connection addresses/ports	✔️	✔️	✔️
	Switch virtual switch	✔️	✔️	✔️
	Request a public endpoint	✔️	✔️	✔️
Monitoring and alerts	View monitoring data	✔️	✔️	✔️
	Set monitoring frequency	✔️	✔️	✔️
	Configure alert rules	✔️	✔️	✔️
Read-only instances and read/write splitting Note Primary instance must be SQL Server 2017 Enterprise Cluster Edition or 2019 Enterprise Cluster Edition.	Create a read-only instance	✔️	✔️	❌
	Enable read/write splitting	✔️	✔️	❌
	Modify read weight distribution	✔️	✔️	❌
	Secondary database read-only access	✔️	✔️	❌
Security management	Configure whitelist	✔️	✔️	✔️
	Configure SSL encryption	✔️	✔️	✔️
	Configure transparent data encryption (TDE)	✔️	2012 Enterprise Edition Single-node: ✔️ Standard High-availability Edition: ❌	✔️
	Configure distributed transaction whitelist Note Instance must run High-availability Edition.	✔️	✔️	✔️
	Disk encryption	✔️	✔️	❌
	SQL Server access to self-managed domain	✔️	✔️	❌
Audit	SQL Audit (Database Audit)	✔️	✔️	✔️
	Log Management	✔️	✔️	✔️
	Historical events	✔️	✔️	✔️
Database backup	Back up data	✔️	✔️	✔️
	Snapshot backup	✔️	✔️	✔️
	Cross-region backup	✔️	✔️	✔️
	Free quota	✔️	✔️	✔️
	Download backup	✔️	✔️	✔️
Database restoration	Restore data	✔️	✔️	✔️
Database restoration	Restore data	When you restore data to an existing instance, restoration is supported only between instances of the same family, or between dedicated and general-purpose instances. Restoration is not supported between shared instances and instances of other families.
Diagnosis and optimization	Autonomous service	✔️	✔️	✔️
Tag management	Create tags	✔️	✔️	✔️
	Detach tags	✔️	✔️	✔️
	Filter instances by tag	✔️	✔️	✔️