tencent cloud

Feedback

Overview

Last updated: 2022-06-07 18:21:27

    TencentDB for SQL Server supports quick adjustment of instance architecture, version, and specification and allows flexible scaling operations in the console. You can elastically adjust the instance configuration according to your actual business conditions (at the initial stage, at the rapid development stage, during peak hours, or during off-peak hours), so as to better meet your needs such as full utilization of resources and real-time cost optimization.

    Prerequisites

    You can adjust the configuration of a TencentDB for SQL Server instance and its associated instances only when they are in normal status (Running) and are not executing any tasks.

    Adjustment Item

    Adjustment Item Description
    Architecture a. High-Availability Edition can be upgraded to Cluster Edition.
    b. Basic Edition cannot be upgraded to High-Availability Edition/Cluster Edition. If needed, you can purchase new High-Availability Edition/Cluster Edition instances and migrate the data with DTS.
    Version a. High-Availability Edition supports version upgrade.
    b. To upgrade the version of a High-Availability Edition/Cluster Edition instance associated with a read-only instance, submit a ticket.
    Instance specification a. All instance types support specification upgrade and downgrade.
    b. The upper limit of disk capacity under the corresponding specification is as displayed on the Adjust Configuration page in the console.
    Disk capacity a. High-Availability Edition/Cluster Edition instances support disk capacity expansion/reduction.
    b. Basic Edition instances support disk capacity expansion but not reduction.
    Note:

    If you need to horizontally scale the read capability of your database, use read-only instances to mitigate the pressure on the primary instance as instructed in Managing Read-Only Instance.

    Restrictions on Upgrade/Downgrade

    Instance Type Version Upgrade Architecture Upgrade Specification Upgrade Disk Capacity Expansion Version Downgrade Architecture Downgrade Specification Downgrade Disk Capacity Reduction
    Basic Edition instance X X X X X
    High-Availability Edition instance X X
    Cluster Edition instance X X X X
    Read-Only instance X X X X

    Instance Disk Space Description

    • To ensure business continuity, upgrade your instance specifications or purchase additional disk capacity in time before disk capacity is used up.
    • When the size of the data stored in a High-Availability Edition/Cluster Edition instance exceeds its disk capacity, features such as database import and rollback will become unavailable. You will need to expand its capacity or delete some database tables in the console to release the storage space.
    • When the size of the data stored in a Basic Edition instance exceeds its disk capacity, the database will become read-only. You will need to expand its capacity or delete some database tables in the console to release the storage space and make it writable.

    Configuration Adjustment Rules

    • You cannot cancel a configuration adjustment operation in progress.
    • The name, access IP, and access port of the instance remain unchanged after configuration adjustment.
    • Data migration may be involved in configuration adjustment. During data migration, the TencentDB for SQL Server instance can be accessed normally and the business will not be affected.
    • Instance switch may be involved after the configuration adjustment is completed (i.e., the SQL Server instance may be disconnected for seconds). We recommend you configure an automatic reconnection feature for your application. Instance switch will be performed during the instance maintenance time. For more information, see Setting Instance Maintenance Information.

    Notes

    As a Basic Edition instance has only one database node and no secondary node as a hot backup, when the node fails or performs tasks such as configuration adjustment and version upgrade, it will become unavailable for a long time. If your business has high requirements for the database availability, we recommend you use High-Availability Edition or Cluster Edition instead of Basic Edition.

    Billing Rule

    For more information, see Instance Adjustment Fees Description.

    Directions

    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