tencent cloud

Feedback

Adjusting Instance Specification

Last updated: 2022-01-19 14:22:53

    This document describes how to adjust the instance specification in the TencentDB for SQL Server console.

    Instance Specification

    For more information on instance specifications supported by TencentDB for SQL Server and their prices, see Product Pricing.

    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.

    Specification Adjustment Process

    Scaling
    After you adjust the configuration in the console, the system will decide to complete the change by scaling or data migration. The configuration adjustment process is as follows:

    Impact of Configuration Adjustment

    Single-Item adjustment

    Single-Item adjustment refers to the adjustment of either the specification or disk, which has the following impact:

    EditionAdjustment ItemAdjustment DecisionAdjustment ImpactTime
    Basic Edition Specification upgrade
    or
    Disk capacity expansion
    or
    Specification downgrade
    Upgrade and downgrade1. The instance will be restarted during configuration adjustment.
    2. The service will become unavailable for around 3 minutes.
    3. Perform the adjustment during off-peak hours.
    You need to select the time to take effect.
    High-Availability Edition/Cluster Edition Disk capacity reductionDowngrade1. The instance disk capacity will be reduced during the configuration adjustment.
    2. Data migration and instance restart will not be performed, and no momentary disconnections will occur.
    3. The submitted adjustment will take effect immediately without affecting the business.
    The submitted adjustment will be executed immediately.
    Specification downgradeDowngrade1. The instance specification will be downgraded during configuration adjustment.
    2. The service will become unavailable for around 1 minute.
    3. Perform the adjustment during off-peak hours.
    You need to select the time to take effect.
    Specification upgrade
    or
    disk capacity expansion
    Migration and upgrade1. Data migration will be involved during the instance configuration adjustment, and the higher the data volume, the longer the data migration time. Access to the instance will not be affected during this period.
    2. A switch will be performed after migration completion, which is accompanied by a disconnection from the database lasting for just seconds. Make sure that your business has a reconnection mechanism.
    3. During the momentary disconnection, most operations related to databases, accounts, and networks cannot be executed. Therefore, be sure to perform the switch during off-peak hours.
    You need to select the time to take effect.
    Specification upgrade
    or
    disk capacity expansion
    Upgrade1. The instance specification or disk capacity will be upgraded or expanded during configuration adjustment.
    2. Data migration and instance restart will not be performed, and no momentary disconnections will occur.
    3. The submitted adjustment will take effect immediately without affecting the business.
    The submitted adjustment will be executed immediately.

    Combo adjustment

    Combo adjustment refers to the adjustment of both the specification and disk capacity, which has the following impact:

    EditionAdjustment ItemAdjustment DecisionAdjustment ImpactTime
    Basic Edition Specification upgrade
    Disk capacity expansion
    Specification downgrade
    Upgrade and downgrade1. The instance will be restarted during configuration adjustment.
    2. The service will become unavailable for around 3 minutes.
    3. Perform the adjustment during off-peak hours.
    You need to select the time to take effect.
    High-Availability Edition/Cluster Edition Specification upgrade + disk capacity expansionUpgrade1. The instance specification or disk capacity will be upgraded or expanded during configuration adjustment.
    2. Data migration and instance restart will not be performed, and no momentary disconnections will occur.
    3. The submitted adjustment will take effect immediately without affecting the business.
    The submitted adjustment will be executed immediately.
    Specification upgrade + disk capacity expansionMigration and upgrade1. Data migration will be involved during the instance configuration adjustment, and the higher the data volume, the longer the data migration time. Access to the instance will not be affected during this period.
    2. A switch will be performed after migration completion, which is accompanied by a disconnection from the database lasting for just seconds. Make sure that your business has a reconnection mechanism.
    3. During the momentary disconnection, most operations related to databases, accounts, and networks cannot be executed. Therefore, be sure to perform the switch during off-peak hours.
    You need to select the time to take effect.
    Specification upgrade + disk capacity reductionUpgrade and downgrade1. The instance specification will be upgraded and the disk capacity will be reduced during configuration adjustment.
    2. Data migration and instance restart will not be performed, and no momentary disconnections will occur.
    3. The submitted adjustment will take effect immediately without affecting the business.
    The submitted adjustment will be executed immediately.
    Specification upgrade + disk capacity reductionMigration, upgrade, and downgrade1. Data migration will be involved during the instance configuration adjustment, and the higher the data volume, the longer the data migration time. Access to the instance will not be affected during this period.
    2. A switch will be performed after migration completion, which is accompanied by a disconnection from the database lasting for just seconds. Make sure that your business has a reconnection mechanism.
    3. During the momentary disconnection, most operations related to databases, accounts, and networks cannot be executed. Therefore, be sure to perform the switch during off-peak hours.
    You need to select the time to take effect.
    Specification downgrade + disk capacity expansionUpgrade and downgrade, or migration, upgrade, and downgrade1. The service may become unavailable for around 1 minute, and data migration may be involved during the instance configuration adjustment, and the higher the data volume, the longer the data migration time. Access to the instance will not be affected during this period.
    2. A switch will be performed after migration completion, which is accompanied by a disconnection from the database lasting for just seconds. Make sure that your business has a reconnection mechanism.
    3. During the momentary disconnection, most operations related to databases, accounts, and networks cannot be executed. Therefore, be sure to perform the switch during off-peak hours.
    You need to select the time to take effect.
    Specification downgrade + disk capacity reductionDowngrade1. The instance specification will be downgraded during configuration adjustment.
    2. The service will become unavailable for around 1 minute.
    3. Perform the adjustment during off-peak hours.
    You need to select the time to take effect.

    Directions

    1. Log in to the TencentDB for SQL Server console, select the region and target instance in the instance list, and click Adjust Configuration in the Operation column.
    2. In the Adjust Configuration window that pops up, select the desired CPU, memory, and disk capacity, and click Confirm.
      Note:

      • ?Select the Time to Take Effect of the configuration adjustment and click the orange note.
        • During maintenance time: you can modify the maintenance time on the instance details page.
        • Adjust now: the configuration adjustment will be performed immediately.
      • If disk capacity reduction is involved, in order to avoid failures, the new disk space must be greater than or equal to 2 times the currently used disk space.
      • If the instance to be adjusted is associated with other instances (read-only instances) and data migration is involved, submit a ticket for assistance.
    3. On the payment page you are redirected to, confirm the configuration information and fees and click Submit Order.
    4. You will be redirected to the instance list. When the instance status changes from Switching (after configuration adjustment) to Running, the specification upgrade is completed. You can query and check the new specification on the Instance List or Instance Details page.
    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