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
Email 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
Note If you want to know more about the limits, you can submit a ticket.

Maximum number of databases

2008 An ApsaraDB RDS instance that runs SQL Server 2008 R2 supports up to 50 databases. In other SQL Server versions, the maximum number of databases varies based on the RDS edition. You can use the following formulas to calculate the 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.