TencentDB for SQL Server supports database creation on the Database Management page of the console. It also supports granting account access to databases.
Number of Databases per Instance
Attention:
To ensure instance stability, when the instance has only 1 CPU core, it is not recommended to lift the database quantity limit. Keep it at 70.
The maximum number of databases that can be created for instances of each specification is related to the value of the max worker threads parameter. If this parameter uses its default value of 0, the maximum number of databases for instances of all editions and specifications is 80. If you set this parameter to a value greater than or equal to 20000, the maximum number of databases for instances of all editions and specifications is related to the number of instance CPU cores. You can refer to the calculation formula below. For how to set parameters, see Setting Instance Parameters.
The SQL Server 2008 R2 Enterprise edition does not support lifting the quantity limit. Its maximum number of databases is 70. For other SQL Server instances, the number of databases is limited by the number of instance CPU cores. The detailed calculation formula is as follows:
Multi-node
2017 Enterprise
2019 Enterprise
2022 Enterprise
2025 Enterprise
The maximum number of databases is related to the instance CPUs. For instances with 4 or fewer CPU cores, the maximum number of databases is 80. For instances with 8 or more CPU cores, the maximum number of databases is 100.
Two-node (formerly High Availability Edition)
2012 Standard/Enterprise
2014 Standard/Enterprise
2016 Standard/Enterprise
Maximum number of databases:
Specifically, take the square root of the number of CPU cores, round the result to one decimal place, multiply it by 40, and then add 80. Assume the resulting value is X. The maximum number of databases is the minimum value between X and 300. For example, a SQL Server 2014 Enterprise (4 cores, 16 GB) instance supports a maximum of 160 databases.
The maximum number of databases is related to the instance CPUs. For instances with fewer than 8 CPU cores, the maximum number of databases is 80. For instances with 8 or more CPU cores, the maximum number of databases is 100.
The maximum number of databases is the minimum value between N and 400, where N is calculated as follows: take the square root of the number of CPU cores, round down the result, and then multiply by 100. For example, an SQL Server 2017 Enterprise instance (4 cores, 16 GB) supports a maximum of 200 databases.
Maximum Number of Databases by Instance CPU Cores and Edition
Maximum Number of Databases for Single-Node (Formerly Basic Edition)
Maximum Number of Databases for Two-Node (Formerly High Availability/Cluster Edition)
Maximum number of databases in multi-node edition
Number of CPU Cores
Single-Node 2008 R2 Enterprise Edition
Single-Node Windows Server 2012/2014/2016/2017/2019/2022/2025 Enterprise Edition
Two-Node Windows Server 2017/2019/2022/2025 Enterprise Edition
1
70
80
2
136
80
4
160
80
8
193
100
12
218
100
16
240
100
24
275
100
32
300
100
48
300
100
64
300
100
96
300
100
Number of CPU Cores
Multi-Node 2017/2019/2022/2025 Enterprise Edition
2
80
4
80
8
100
12
100
16
100
24
100
32
100
48
100
64
100
96
100
Operation Steps
1. Log in to the TencentDB for SQL Server console and click Instance ID or Manage in the Operation column in the instance list to enter the instance management page.
2. On the instance management page, select the Database Management page, click Create Database, enter relevant information in the pop-up dialog box, and then click OK after confirmation.
Database Name: It consists of letters, digits, and underscores, starts with a letter, and has a maximum length of 64 characters.
Support Character Set: Select the character set used by the database. Most native character sets are currently supported.
Authorize Account: You can grant permissions to existing accounts for this database. If no account has been created, see Account Creation.
Remarks: Enter remarks, with a maximum of 256 characters.
