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.
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.
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:
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.
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. 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.
Yes
No
Was this page helpful?