TencentDB for SQL Server only offers instances with attached licenses. When an instance is created, it is licensed with the appropriate Microsoft SQL Server edition. You cannot bring your own license.
In order to ensure the stability and security of instances, TencentDB for SQL Server has certain restrictions on usage as detailed below.
TencentDB for SQL Server is available in two editions: single-node edition (formerly Basic Edition) and two-node edition (formerly High Availability/Cluster Edition), each with its own set of features. For more information, see Features and Differences.
Note:
If you have other questions about usage restrictions, submit a ticket for assistance.
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
Database quantity
Note:
For a two-node (formerly High Availability/Cluster Edition) instance, if you set 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.
If the instance only has one CPU core, we recommend that you keep the database quantity limit at 70 to guarantee instance stability.
SQL Server 2008 R2 Enterprise instances don't support lifting the database quantity limit, which is 70. The limit in other SQL Server instances is subject to the number of instance CPU cores as calculated below:
Two-node (formerly High Availability Edition)
2012 Standard/Enterprise
2014 Standard/Enterprise
2016 Standard/Enterprise
Maximum number of databases:
Extract the square root of the CPU core quantity, round it to one decimal place, multiply the result by 40, and add the product to 80 to get the value X. The smaller value between X and 300 is the maximum number of databases. For example, you can create up to 160 databases in a 4-core 16 GB MEM SQL Server 2014 Enterprise instance.
The maximum number of databases is related to the instance CPU. The maximum number of databases for instances with 8-core CPU or less is 80, and the maximum number of databases for instances with 8-core CPU or above is 100.
Extract the square root of the CPU core quantity, round it down to the nearest integer, and multiply the result by 100 to get the value N. The smaller value between N and 400 is the maximum number of databases. For example, you can create up to 200 databases in a 4-core 16 GB MEM SQL Server 2017 Enterprise instance.
Table of instance CPU core quantity and corresponding database quantity limit
Database quantity limit for two-node edition (formerly High Availability/Cluster Edition)
Database quantity limit for single-node edition (formerly Basic Edition)
Yes
No
Was this page helpful?