Features - ApsaraDB RDS - Alibaba Cloud Documentation Center

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

Note

ApsaraDB RDS for SQL Server supports multiple versions and editions of SQL Server, such as SQL Server 2022, SQL Server 2019, SQL Server EE, SQL Server SE, and SQL Server Web. Each SQL Server edition provides different capabilities in computing scale, high availability, parallel processing and performance optimization, data security, management and development, and data warehousing. For more information, see Features of ApsaraDB RDS instances that run different SQL Server versions and RDS editions.
The features of SQL Server versions that are supported by ApsaraDB RDS may be different from the features of Microsoft SQL Server versions. For more information, see Microsoft documentation.

SQL Server 2022

Category	Feature	SQL Server EE	SQL Server SE	SQL Server Web
		RDS Cluster Edition	RDS High-availability Edition	RDS Basic Edition
		PL1 ESSD to PL3 ESSD	PL1 ESSD to PL3 ESSD	PL1 ESSD to PL3 ESSD
Data migration	Data migration	✔️	✔️	✔️
Instance management	Instance creation	✔️	✔️	✔️
	Specification change	✔️	✔️	✔️
	Cross-zone migration	❌	❌	❌
	Primary/secondary switchover	✔️	✔️	❌
	Instance suspension	✔️	✔️	✔️
	Instance restart	✔️	✔️	✔️
	Maintenance window setting	✔️	✔️	✔️
	Instance release	✔️	✔️	✔️
	Recycle bin	✔️	✔️	✔️
	DBCC	✔️	✔️	✔️
Account management	Account creation	✔️	✔️	✔️
	Password reset	✔️	✔️	✔️
	Account permission modification	✔️	✔️	✔️
	Service account authorization	❌	❌	❌
	Account deletion	✔️	✔️	✔️
Database management	Database creation	✔️	✔️	✔️
	Database deletion	✔️	✔️	✔️
	Database replication	✔️	✔️	✔️
Database connection management	Instance connection	✔️	✔️	✔️
	Endpoint setting	✔️	✔️	✔️
	Endpoint and port viewing	✔️	✔️	✔️
	vSwitch change	✔️	✔️	✔️
	Public endpoint application	✔️	✔️	✔️
Monitoring and alerting	Metric viewing	✔️	✔️	✔️
	Monitoring frequency setting	✔️	✔️	✔️
	Alert rule setting	✔️	✔️	✔️
Read-only instance management and read/write splitting	Read-only instance creation	✔️	❌	❌
	Read/write splitting	✔️	❌	❌
	Read weight modification	✔️	❌	❌
	Secondary instance restart	✔️	❌	❌
	Read attribute configuration for a secondary instance	✔️	❌	❌
Security management	Whitelist setting	✔️	✔️	✔️
	SSL encryption setting	✔️	✔️	✔️
	Transparent data encryption (TDE) configuration	❌	❌	❌
	Distributed transaction whitelist setting	❌	✔️	❌
	Cloud disk encryption	✔️	✔️	✔️
Auditing	SQL Audit	✔️	✔️	✔️
	Log management	✔️	✔️	✔️
	Historical event viewing	✔️	✔️	✔️
Data backup	Data backup	✔️	✔️	✔️
	Snapshot backup	✔️	✔️	✔️
	Cross-region backup	✔️	✔️	✔️
	Free quota on backup storage	✔️	✔️	✔️
	Backup download	✔️	✔️	✔️
Restoration	Data restoration	✔️	✔️	✔️
Diagnostics and optimization	Autonomy service	✔️	✔️	✔️
Tag management	Tag creation	✔️	✔️	✔️
	Tag removal	✔️	✔️	✔️
	Tag-based instance search	✔️	✔️	✔️

SQL Server 2019

Category	Feature	Serverless	Regular instance
		SQL Server SE	SQL Server EE		SQL Server SE		SQL Server Web
		RDS High-availability Edition	RDS Cluster Edition		RDS High-availability Edition		RDS Basic Edition
		PL1 ESSD	Standard SSD	PL1 ESSD to PL3 ESSD	Standard SSD	PL1 ESSD to PL3 ESSD	Standard SSD	PL1 ESSD
Data migration	Data migration	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Instance management	Instance creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Specification change	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Cross-zone migration	❌	❌	❌	❌	❌	❌	❌
	Primary/secondary switchover	✔️	✔️	✔️	✔️	✔️	❌	❌
	Instance suspension	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Instance restart	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Maintenance window setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Instance release	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Recycle bin	❌	✔️	✔️	✔️	✔️	✔️	✔️
	DBCC	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Account management	Account creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Password reset	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Account permission modification	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Service account authorization	❌	❌	❌	❌	❌	❌	❌
	Account deletion	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Database management	Database creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Database deletion	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Database replication	❌	✔️	✔️	✔️	✔️	✔️	✔️
Database connection management	Instance connection	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Endpoint setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Endpoint and port viewing	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	vSwitch change	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Public endpoint application	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Monitoring and alerting	Metric viewing	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Monitoring frequency setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Alert rule setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Read-only instance management and read/write splitting	Read-only instance creation	❌	✔️	✔️	❌	❌	❌	❌
	Read/write splitting	❌	✔️	✔️	❌	❌	❌	❌
	Read weight modification	❌	✔️	✔️	❌	❌	❌	❌
	Secondary instance restart	❌	✔️	✔️	❌	❌	❌	❌
	Read attribute configuration for a secondary instance	❌	✔️	✔️	❌	❌	❌	❌
Security management	Whitelist setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	SSL encryption setting	❌	✔️	✔️	✔️	✔️	✔️	✔️
	TDE configuration	❌	✔️	✔️	✔️	✔️	❌	❌
	Distributed transaction whitelist setting	❌	❌	❌	✔️	✔️	❌	❌
	Cloud disk encryption	❌	✔️	✔️	✔️	✔️	✔️	✔️
Auditing	SQL Audit	❌	✔️	✔️	✔️	✔️	✔️	✔️
	Log management	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Historical event viewing	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Data backup	Data backup	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Snapshot backup	❌	✔️	✔️	✔️	✔️	✔️	✔️
	Cross-region backup	❌	✔️	✔️	✔️	✔️	✔️	✔️
	Free quota on backup storage	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Backup download	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Restoration	Data restoration	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Diagnostics and optimization	Autonomy service	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Tag management	Tag creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Tag removal	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Tag-based instance search	✔️	✔️	✔️	✔️	✔️	✔️	✔️

SQL Server 2017

Category	Feature	Serverless	Regular instance
		SQL Server SE	SQL Server EE		SQL Server SE		SQL Server Web
		RDS High-availability Edition	RDS Cluster Edition		RDS High-availability Edition		RDS Basic Edition
		PL1 ESSD	Standard SSD	PL1 ESSD to PL3 ESSD	Standard SSD	PL1 ESSD to PL3 ESSD	Standard SSD	PL1 ESSD
Data migration	Data migration	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Instance management	Instance creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Specification change	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Cross-zone migration	❌	❌	❌	❌	❌	❌	❌
	Primary/secondary switchover	✔️	✔️	✔️	✔️	✔️	❌	❌
	Instance suspension	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Instance restart	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Maintenance window setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Instance release	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Recycle bin	❌	✔️	✔️	✔️	✔️	✔️	✔️
	DBCC	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Account management	Account creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Password reset	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Account permission modification	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Service account authorization	❌	❌	❌	❌	❌	❌	❌
	Account deletion	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Database management	Database creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Database deletion	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Database replication	❌	✔️	✔️	✔️	✔️	✔️	✔️
Database connection management	Instance connection	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Endpoint setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Endpoint and port viewing	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	vSwitch change	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Public endpoint application	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Monitoring and alerting	Metric viewing	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Monitoring frequency setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Alert rule setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Read-only instance management and read/write splitting	Read-only instance creation	❌	✔️	✔️	❌	❌	❌	❌
	Read/write splitting	❌	✔️	✔️	❌	❌	❌	❌
	Read weight modification	❌	✔️	✔️	❌	❌	❌	❌
	Secondary instance restart	❌	✔️	✔️	❌	❌	❌	❌
	Read attribute configuration for a secondary instance	❌	✔️	✔️	❌	❌	❌	❌
Security management	Whitelist setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	SSL encryption setting	❌	✔️	✔️	✔️	✔️	✔️	✔️
	TDE configuration	❌	✔️	✔️	❌	❌	❌	❌
	Distributed transaction whitelist setting	❌	❌	❌	✔️	✔️	❌	❌
	Cloud disk encryption	❌	✔️	✔️	✔️	✔️	✔️	✔️
Auditing	SQL Audit	❌	✔️	✔️	✔️	✔️	✔️	✔️
	Log management	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Historical event viewing	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Data backup	Data backup	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Snapshot backup	❌	✔️	✔️	✔️	✔️	✔️	✔️
	Cross-region backup	❌	✔️	✔️	✔️	✔️	✔️	✔️
	Free quota on backup storage	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Backup download	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Restoration	Data restoration	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Diagnostics and optimization	Autonomy service	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Tag management	Tag creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Tag removal	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Tag-based instance search	✔️	✔️	✔️	✔️	✔️	✔️	✔️

SQL Server 2016

Category	Feature	Serverless	Regular instance
		SQL Server SE	SQL Server EE				SQL Server SE		SQL Server Web
		RDS High-availability Edition	RDS High-availability Edition		RDS Basic Edition		RDS High-availability Edition		RDS Basic Edition
		PL1 ESSD	Standard SSD	PL1 ESSD to PL3 ESSD	Standard SSD	ESSD	Standard SSD	PL1 ESSD to PL3 ESSD	Standard SSD	ESSD
Data migration	Data migration	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Instance management	Instance creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Specification change	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Cross-zone migration	❌	❌	❌	❌	❌	❌	❌	❌	❌
	Primary/secondary switchover	✔️	✔️	✔️	❌	❌	✔️	✔️	❌	❌
	Instance suspension	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Instance restart	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Maintenance window setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Instance release	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Recycle bin	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	DBCC	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Instance upgrade	Upgrade from RDS Basic Edition to RDS High-availability Edition	❌	❌	❌	✔️	✔️	❌	❌	✔️	✔️
Account management	Account creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Password reset	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Account permission modification	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Service account authorization	❌	❌	❌	❌	❌	❌	❌	❌	❌
	Account deletion	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Database management	Database creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Database deletion	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Database replication	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Database connection management	Instance connection	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Endpoint setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Endpoint and port viewing	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	vSwitch change	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Public endpoint application	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Monitoring and alerting	Metric viewing	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Monitoring frequency setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Alert rule setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Read-only instance management and read/write splitting	Read-only instance creation	❌	❌	❌	❌	❌	❌	❌	❌	❌
	Read/write splitting	❌	❌	❌	❌	❌	❌	❌	❌	❌
	Read weight modification	❌	❌	❌	❌	❌	❌	❌	❌	❌
Security management	Whitelist setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	SSL encryption setting	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	TDE configuration	❌	✔️	✔️	✔️	✔️	❌	❌	❌	❌
	Distributed transaction whitelist setting	❌	✔️	✔️	❌	❌	✔️	✔️	❌	❌
	Cloud disk encryption	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Auditing	SQL Audit	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Log management	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Historical event viewing	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Data backup	Data backup	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Snapshot backup	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Cross-region backup	❌	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Free quota on backup storage	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Backup download	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Restoration	Data restoration	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Diagnostics and optimization	Autonomy service	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Tag management	Tag creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Tag removal	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Tag-based instance search	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️

SQL Server 2012

Category	Feature	SQL Server EE		SQL Server EE Basic		SQL Server SE		SQL Server Web
		RDS High-availability Edition		RDS Basic Edition		RDS High-availability Edition		RDS Basic Edition
		Standard SSD	PL1 ESSD to PL3 ESSD	Standard SSD	PL1 ESSD	Standard SSD	PL1 ESSD to PL3 ESSD	Standard SSD	PL1 ESSD
Data migration	Data migration	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Instance management	Instance creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Specification change	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Cross-zone migration	❌	❌	❌	❌	❌	❌	❌	❌
	Primary/secondary switchover	✔️	✔️	❌	❌	✔️	✔️	❌	❌
	Instance suspension	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Instance restart	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Maintenance window setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Instance release	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Recycle bin	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	DBCC	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Instance upgrade	Upgrade from RDS Basic Edition to RDS High-availability Edition	❌	❌	✔️	✔️	❌	❌	✔️	✔️
Instance upgrade	Upgrade from SQL Server 2012 to SQL Server 2016	❌	❌	✔️	✔️	❌	❌	✔️	✔️
Account management	Account creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Password reset	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Account permission modification	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Service account authorization	❌	❌	❌	❌	❌	❌	❌	❌
	Account deletion	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Database management	Database creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Database deletion	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Database replication	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Database connection management	Instance connection	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Endpoint setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Endpoint and port viewing	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	vSwitch change	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Public endpoint application	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Monitoring and alerting	Metric viewing	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Monitoring frequency setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Alert rule setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Read-only instance management and read/write splitting	Read-only instance creation	❌	❌	❌	❌	❌	❌	❌	❌
	Read/write splitting	❌	❌	❌	❌	❌	❌	❌	❌
	Read weight modification	❌	❌	❌	❌	❌	❌	❌	❌
Security management	Whitelist setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	SSL encryption setting	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	TDE configuration	✔️	✔️	✔️	✔️	❌	❌	❌	❌
	Distributed transaction whitelist setting	✔️	✔️	❌	❌	✔️	✔️	❌	❌
Auditing	Log management	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Data backup	Data backup	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Snapshot backup	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Cross-region backup	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Free quota on backup storage	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Backup download	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Restoration	Data restoration	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Tag management	Tag creation	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Tag removal	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
	Tag-based instance search	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️

SQL Server 2008 R2

Category	Feature	RDS High-availability Edition
Category	Feature	Local SSD	Standard SSD	PL1 ESSD to PL3 ESSD
Data migration	Data migration	✔️	✔️	✔️
Instance management	Instance creation	✔️	✔️	✔️
	Specification change	✔️	✔️	✔️
	Cross-zone migration	✔️	❌	❌
	Primary/secondary switchover	✔️	✔️	✔️
	Instance suspension	❌	✔️	✔️
	Instance restart	✔️	✔️	✔️
	Maintenance window setting	✔️	✔️	✔️
	Instance release	✔️	✔️	✔️
	Recycle bin	✔️	✔️	✔️
	DBCC	❌	✔️	✔️
Instance upgrade	Upgrade from SQL Server 2008 R2 to SQL Server 2012 or SQL Server 2016	✔️	❌	❌
Account management	Account creation	✔️	✔️	✔️
	Password reset	✔️	✔️	✔️
	Account permission modification	✔️	✔️	✔️
	Service account authorization	✔️	❌	❌
	Account deletion	✔️	✔️	✔️
Database management	Database creation	✔️	✔️	✔️
	Database deletion	✔️	✔️	✔️
	Database replication	✔️	✔️	✔️
Database connection management	Instance connection	✔️	✔️	✔️
	Endpoint setting	✔️	✔️	✔️
	Endpoint and port viewing	✔️	✔️	✔️
	vSwitch change	❌	✔️	✔️
	Public endpoint application	✔️	✔️	✔️
Monitoring and alerting	Metric viewing	✔️	✔️	✔️
	Monitoring frequency setting	✔️	✔️	✔️
	Alert rule setting	✔️	✔️	✔️
Read-only instance management and read/write splitting	Read-only instance creation	❌	❌	❌
	Read/write splitting	❌	❌	❌
	Read weight modification	❌	❌	❌
Security management	Whitelist setting	✔️	✔️	✔️
	SSL encryption setting	✔️	✔️	✔️
	TDE configuration	✔️	✔️	✔️
	Distributed transaction whitelist setting	❌	❌	❌
	Cloud disk encryption	❌	✔️	✔️
Auditing	SQL Audit	✔️	✔️	✔️
	Log management	✔️	✔️	✔️
	Historical event viewing	✔️	✔️	✔️
Data backup	Data backup	✔️	✔️	✔️
	Snapshot backup	❌	✔️	✔️
	Cross-region backup	❌	✔️	✔️
	Free quota on backup storage	✔️	✔️	✔️
	Backup download	✔️	✔️	✔️
Restoration	Data restoration	✔️	✔️	✔️
Diagnostics and optimization	Autonomy service	✔️	❌	❌
Tag management	Tag creation	✔️	✔️	✔️
	Tag removal	✔️	✔️	✔️
	Tag-based instance search	✔️	✔️	✔️