tencent cloud

Feedback

Adjusting Instance Specification

Last updated: 2024-05-10 16:21:27

    Instance Specifications

    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 running status and are not executing any tasks.

    Specification Adjustment Process

    Scaling After you adjust the configuration in the console, the system will determine whether to complete the adjustment by in-place 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:
    Instance Architecture
    Disk Type
    Adjustment Item
    Adjustment Decision
    Adjustment Impact
    Time
    Single-node instance (formerly basic edition)
    Cloud disk
    Specification upgrade or disk capacity expansion or specification downgrade
    Upgrade and downgrade
    1. The instance will be restarted during configuration adjustment.
    2. The service will become unavailable for about 3 minutes.
    3. Perform the adjustment during off-peak hours.
    You need to select the time to take effect.
    Two-node instance (formerly high-availability edition)
    Local disk
    Disk capacity reduction
    Downgrade
    1. 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. You can custom the effective time that is also the adjustment time without affecting the business.
    You can select the time to take effect.
    Specification downgrade
    Downgrade
    1. 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 upgradeordisk capacity expansion
    Migration and upgrade
    1. Data migration will be involved during the instance configuration adjustment, and the larger 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 is completed, which causes a momentary disconnection from the database for few seconds. Make sure that your business has a reconnection mechanism.
    3. Most database, account, and network operations are unavailable during the momentary disconnection. Therefore, we recommend that you perform the switch during off-peak hours.
    You need to select the time to take effect.
    Specification upgrade or disk capacity expansion
    Upgrade
    1. 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. You can customize the effective time that is also the adjustment time without affecting the business.
    You can select the time to take effect.
    Two-node instances (formerly high-availability edition)
    Cloud disk
    Specification upgrade or disk capacity expansionorspecification downgrade
    Migration, upgrade, and downgrade
    1. Data migration will be involved during the instance configuration adjustment, and the larger 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 is completed, which causes a momentary disconnection from the database for 30 seconds to 2 minutes. Make sure that your business has a reconnection mechanism.
    3. Most database, account, and network operations are unavailable during the momentary disconnection. Therefore, we recommend that you perform the switch during off-peak hours.
    You need to select the time to take effect.

    Combo adjustment

    Combo adjustment refers to the adjustment of both the specification and disk capacity, which has the following impact:
    Instance Architecture
    Disk Type
    Adjustment Item
    Adjustment Decision
    Adjustment Impact
    Time
    Single-node instance (formerly basic edition)
    Cloud disk
    Specification upgradeDisk capacity expansionSpecification downgrade
    Upgrade and downgrade
    1. 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.
    Two-node instance (formerly high-availability edition)
    Local disk
    Specification upgrade + disk capacity expansion
    Upgrade
    1. 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. You can custom the effective time that is also the adjustment time without affecting the business.
    You can select the time to take effect.
    Specification upgrade + disk capacity expansion
    Migration and upgrade
    1. Data migration will be involved during the instance configuration adjustment, and the larger 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 is completed, which causes a momentary disconnection from the database for few seconds. Make sure that your business has a reconnection mechanism.
    3. Most database, account, and network operations are unavailable during the momentary disconnection. Therefore, we recommend you perform the switch during off-peak hours.
    You need to select the time to take effect.
    Specification upgrade + disk capacity reduction
    Upgrade and downgrade
    1. 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 time to take effect (i.e., the time when the configuration adjustment will occur) can be customized without affecting the business.
    The time to take effect can be customized.
    Specification upgrade + disk capacity reduction
    Migration, upgrade, and downgrade
    1. Data migration will be involved during the instance configuration adjustment, and the larger 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 is completed, which causes a momentary disconnection from the database for few seconds. Make sure that your business has a reconnection mechanism.
    3. Most database, account, and network operations are unavailable during the momentary disconnection. Therefore, we recommend you perform the switch during off-peak hours.
    You need to select the time to take effect.
    Specification downgrade + disk capacity expansion
    Upgrade and downgrade, or migration, upgrade, and downgrade
    1. The service may become unavailable for around 1 minute, and data migration may be involved during the instance configuration adjustment, and the larger 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 is completed, which causes a momentary disconnection from the database for few seconds. Make sure that your business has a reconnection mechanism.
    3. Most database, account, and network operations are unavailable during the momentary disconnection. Therefore, we recommend you perform the switch during off-peak hours.
    You need to select the time to take effect.
    Specification downgrade + disk capacity reduction
    Downgrade
    1. 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.
    Two-node instance (formerly high-availability edition)
    Cloud disk
    Specification upgradeDisk expansionSpecification downgrade
    Migration, upgrade, and downgrade
    1. Data migration will be involved during the instance configuration adjustment, and the larger 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 is completed, which causes a momentary disconnection from the database for 30 seconds to 2 minutes. Make sure that your business has a reconnection mechanism.
    3. Most database, account, and network operations are unavailable during the momentary disconnection. Therefore, we recommend that you perform the switch 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 OK.
    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 read-only instances and data migration is involved, submit a ticket for assistance.
    
    3. In the redirected payment window for monthly subscription instances, confirm the configuration details and fees, and then click Submit Order. For pay-as-you-go instances, click Adjust in the window.
    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