tencent cloud

Feedback

Constraints and Limits

Last updated: 2022-12-02 12:04:26

    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 three editions: Basic, Dual-Server High Availability, and Cluster, 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.

    FeatureCluster EditionDual-Server High Availability EditionBasic Edition
    Database version2017 Enterprise
    2019 Enterprise
    2008 R2 Enterprise
    2012 Standard/Enterprise
    2014 Standard/Enterprise
    2016 Standard/Enterprise
    2008 R2 Enterprise
    2012 Enterprise
    2014 Enterprise
    2016 Enterprise
    2017 Enterprise
    2019 Enterprise
    Maximum number of databases (subject to the number of instance CPU cores as described in Constraints and Limits)2017: 340
    2019: 340
    2008 R2: 70
    2012/2014/2016: 300
    400
    Maximum number of database accountsUnlimitedUnlimitedUnlimited
    Database creationSupportedSupportedSupported
    User/Login account creation and deletionSupportedSupportedSupported
    SA account creationNot supportedNot supportedSupported
    Database authorizationSupportedSupportedSupported
    Database-level DDL triggerSupportedSupportedSupported
    Thread killing permissionSupportedSupportedSupported
    SQL profilerSupportedSupportedSupported
    Pub/SubSupportedSupportedNot supported
    Optimization advisorNot supportedNot supportedSupported
    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)SupportedSupportedSupported
    Change tracking (CT)SupportedSupportedSupported
    Windows domain account loginNot supportedNot supportedNot supported
    MailingNot supportedNot supportedNot supported
    SQL Server Integration Services (SSIS)SupportedSupportedSupported
    SQL Server Analysis Services (SSAS)Not supportedNot supportedNot supported
    SQL Server Reporting Services (SSRS)Not supportedNot supportedNot supported
    R language serviceNot supportedNot supportedNot supported
    Common Language Runtime (CLR) integrationNot supportedNot supportedNot supported
    Async messagingNot supportedNot supportedNot supported
    Policy managementNot supportedNot supportedNot supported

    Database quantity

    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:

    • 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.
    • Cluster Edition
      2017 Enterprise
      2019 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 120 to get the value Y. The smaller value between Y and 340 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.
    • Basic Edition
      2008 R2 Enterprise
      2012 Enterprise
      2014 Enterprise
      2016 Enterprise
      2017 Enterprise
      2019 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

    CPU CoresDual-Server High Availability EditionCluster Edition
    17070
    2136176
    4160200
    8193233
    12218258
    16240280
    24275315
    32300340
    48300340
    64300340
    96300340
    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