Feature | Two-Node Edition | Single-Node Edition |
Database version | 2008 R2 Enterprise
2012 Enterprise
2014 Enterprise
2016 Enterprise
2017 Enterprise
2019 Enterprise
2022 Enterprise | |
Maximum number of databases (subject to the number of instance CPU cores as described in Constraints and Limits > Database quantity) | 2008 R2 version: 300 2012, 2014, and 2016 versions: 300 2017, 2019, and 2022 versions: 100 | 400 |
Maximum number of database accounts | Unlimited | Unlimited |
Database creation | Supported | Supported |
User/Login account creation and deletion | Supported | Supported |
SA account creation | Not supported | Supported |
Database authorization | Supported | Supported |
Database-level DDL trigger | Supported | Supported |
Thread killing permission | Supported | Supported |
SQL profiler | Supported | Supported |
Publish/Subscribe | Supported | Not supported |
Optimization advisor | Not supported | Supported |
Linked server | Supported only in Tencent Cloud private network Not supported between other clouds/self-built environments and Tencent Cloud | |
Distributed transaction | Supported only in Tencent Cloud private network Not supported between other clouds/self-built environments and Tencent Cloud | |
Change data capture (CDC) | Supported | Supported |
Change tracking (CT) | Supported | Supported |
Windows domain account login | Not supported | Not supported |
Email | Not supported | Not supported |
SQL Server Integration Services (SSIS) | Supported | Supported |
SQL Server Analysis Services (SSAS) | Not supported | Not supported |
SQL Server Reporting Services (SSRS) | Not supported | Not supported |
R language service | Not supported | Not supported |
Common Language Runtime (CLR) integration | Not supported | Not supported |
Async messaging | Not supported | Not supported |
Policy management | Not supported | Not supported |
max worker threads
to the default value 0, you can create no more than 100 databases. To create more databases, you must set this parameter to 20,000 as instructed in Setting Instance Parameters.CPU cores | Two-node 2008 R2/2012/2014/2016 Enterprise | Two-node 2017/2019/2022 Enterprise |
1 | 70 | 70 |
2 | 136 | 176 |
4 | 160 | 200 |
8 | 193 | 233 |
12 | 218 | 258 |
16 | 240 | 280 |
24 | 275 | 315 |
32 | 300 | 340 |
48 | 300 | 340 |
64 | 300 | 340 |
96 | 300 | 340 |
Number of CPU Cores | Single Node 2008 R2 Enterprise Edition | Single-node 2012/2014/2016/2017/2019/2022 Enterprise Edition |
2 | 80 | 100 |
4 | 80 | 200 |
8 | 80 | 200 |
12 | 80 | 300 |
16 | 80 | 400 |
24 | 80 | 400 |
32 | 80 | 400 |
48 | 80 | 400 |
64 | 80 | 400 |
Was this page helpful?