This topic describes the limits of ApsaraDB RDS for SQL Server. Before you use ApsaraDB RDS for SQL Server, we recommend that you familiarize yourself with these limits to ensure the stability and security of your database system.
Item | RDS Cluster Edition | RDS High-availability Edition | RDS Basic Edition | |
---|---|---|---|---|
SQL Server 2019 EE SQL Server 2017 EE |
SQL Server 2019 SE SQL Server 2017 SE SQL Server 2016 SE and SQL Server 2016 EE SQL Server 2012 SE and SQL Server 2012 EE |
SQL Server 2008 R2 R2 |
SQL Server 2012 Web and SQL Server 2016 Web SQL Server 2012 SE and SQL Server 2016 SE SQL Server 2012 EE Basic SQL Server 2016 EE |
|
Maximum number of databases (For more information, see the "Maximum number of databases" section of this topic.) | 300 | 300 | 50 | 400 |
Maximum number of database accounts | Unlimited | Unlimited | 500 | Unlimited |
Creation of accounts, logon connections, and databases | Supported | Supported | Supported | Supported |
Database-level DDL triggers | Supported | Supported | Not supported | Supported |
Database permission authorization | Supported | Supported | Not supported | Supported |
Permissions to terminate threads | Supported | Supported | Supported | Supported |
Linked Server | Supported (Linked servers are not supported for the shared instance family.) | Supported (Linked servers are not supported for the shared instance family.) | Not supported | Not supported |
Distributed transactions | Supported | Supported | Not supported | Not supported |
SQL Profiler | Supported | Supported | Supported | Supported |
Tuning Advisor | Supported | Supported | Not supported | Supported |
Change data capture (CDC) | Supported | Not supported | Not supported | Not supported |
Change tracking | Supported | Supported | Not supported | Supported |
Windows domain account logon | Supported (Windows domain account logon is not supported for the shared instance family.) | Supported (Windows domain account logon is not supported for the shared instance family.) | Not supported | Not supported |
Not supported | Not supported | |||
SQL Server Integration Services (SSIS) | ||||
SQL Server Analysis Services (SSAS) | ||||
SQL Server Reporting Services (SSRS) | ||||
R Services | ||||
Common Language Runtime (CLR) | ||||
Asynchronous communication | ||||
Replication | ||||
Policy management |
Maximum number of databases
- RDS Cluster Edition and RDS High-availability Edition
The maximum number that is obtained from the preceding formula cannot exceed 300.
- RDS Basic Edition
The maximum number that is obtained from the preceding formula cannot exceed 400.