tencent cloud

Feedback

Creating Database

Last updated: 2024-04-11 09:43:24

    Overview

    TencentDB for SQL Server allows you to create databases on the Database Management page in the console and authorize accounts for database access.

    Maximum number of databases created in a single instance

    Note:
    In a High Availability or Cluster Edition instance, if you use the default value of 0 for the max worker threads parameter, you cannot create 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 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:
    Dual-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.
    Dual-Node (Formerly Cluster Edition) 2017 Enterprise 2019 Enterprise
    2022 Enterprise
    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.
    Single Node (Formerly Basic Edition) 2008 R2 Enterprise 2012 Enterprise 2014 Enterprise 2016 Enterprise 2017 Enterprise 2019 Enterprise
    2022 Enterprise Maximum number of databases:
    
    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 maximum database quantity
    Maximum number of databases in Dual-Server High Availability/Cluster Edition
    Maximum number of databases in Basic Edition
    CPU Cores
    Dual-Node 2008 R2/2012/2014/2016 Enterprise Edition
    Dual-node 2017/2019/2022 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
    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

    Directions

    1. Log in to the TencentDB for SQL Server console and click the ID of the target instance in the instance list or Manage in the Operation column to enter the instance management page.
    2. On the instance management page, select the Database Management tab, click Create Database, set configuration items in the pop-up window, confirm that everything is correct, and click OK.
    
    Database Name: It can contain up to 32 letters, digits, and underscores and must start with a letter.
    Supported Character Set: Select the character set to be used by the database. Currently, most native character sets are supported.
    Authorize Account: You can authorize existing accounts to access the database. If you haven't created an account yet, see Creating Account.
    Remarks: It can contain up to 256 characters.
    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support