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 | | |
Distributed transaction | Only supported by two-node local disk instances | Not supported |
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 |
Cross-Architecture Direction | Description |
Two-node instance → single-node instance | Not supported. |
Single-node instance → two-node instance | Not supported. |
Local disk instance → cloud disk instance | Not supported. |
Cloud disk instance → local disk instance | Not supported. |
Cross-Architecture Direction | Description |
Two-node local disk instance → two-node local disk instance | Interconnection is supported between domestic regions, and interconnection is supported between overseas regions, but not between domestic and overseas regions. |
Two-node cloud disk instance → two-node cloud disk instance | Only interconnection within the same region is supported. |
Was this page helpful?