Setting Disk Additional I/O Performance
Download
Focus Mode
Font Size
This document describes how to configure additional disk I/O performance and provides related information.
Note:
When you perform operations such as cross-AZ migration / instance specification adjustment / instance edition upgrade that trigger a data migration scenario, system databases are not migrated. Do not create business-related data under system databases to avoid data loss after migration. Furthermore, under the aforementioned operation scenarios, non-standard system database operations and instance-level operations are not migrated together. You must handle them manually after the migration is completed.
Supported Versions
Single-node, two-node, multi-node, and read-only instances of the Cloud Disk Edition architecture are all supported.
Currently, only Enhanced SSD supports configuring additional I/O performance..
Feature Usage Conditions
Currently, additional disk I/O performance can be configured only for Enhanced SSD CBS with a storage capacity greater than or equal to 460 GB.
Disk Additional Performance
Storage Type | Additional Performance Category | Calculation Formula for Additional Performance |
Enhanced SSD | Random IOPS | Min{Configuration value x 128, 50,000} |
| Maximum throughput (MB/s) | Min{Configuration value x 1, 650} |
Configuration Value: You can customize additional performance. The configuration value range is 0 - 650.
Billing for Disk Additional I/O Performance
Using additional disk I/O performance incurs charges. For billing details, see Additional Disk I/O Performance Billing.
Performance Change and Impact Description
Change Operation | Scenario | Impact Description |
Change only the additional disk I/O performance. | No underlying machine type change involved. | During the configuration adjustment process, the instance does not affect business operations. You can select an effective time, which is the actual time when the configuration change takes effect. |
| Underlying machine type change involved. | During the configuration adjustment process, the instance will be restarted, resulting in service unavailability for approximately 1 to 3 minutes. Perform operations during off-peak hours allowed by the business. |
| Insufficient resources | No resources are currently available for this specification. Change the specification. |
Operation Steps
Setting Disk Additional I/O Performance When Creating an Instance
You can log in to the TencentDB for SQL Server purchase page. When creating a new instance, select an instance that meets the edition and architecture requirements. Then, configure the Additional performance option as needed. For the complete configuration steps on the purchase page, see Purchase Methods.
Setting Disk Additional I/O Performance for Existing Instances
1. Log in to the TencentDB for SQL Server console, click the Instance ID or Manage in the Operation column, and go to the instance management page.
2. In the Instance Information section on the right side of the instance details page, locate the primary node information and click Adjust Performance after Disk Performance.
3. In the pop-up window, configure additional performance, pass the resource check, select the effective time, and then click OK.
Additional Performance: 0 - 650, with a step size of 10.
Resource Inspection: The system performs a resource pre-check to determine whether the selected specification configuration has sufficient resources. If resources are sufficient, the check passes, and you can proceed to the next step. If resources are insufficient, change the configuration and perform the resource pre-check again. You can proceed to the next step only after the pre-check passes.
Time to Take Effect:
During Maintenance time: This indicates that the change takes effect during the maintenance window. You can modify the maintenance time on the instance details page.
Adjust now: This indicates that the change takes effect immediately after the task is submitted.
Viewing Disk Performance of an Instance
1. Log in to the TencentDB for SQL Server console, click the Instance ID or Manage in the Operation column, and go to the instance management page.
2. In the Instance Information section on the right side of the instance details page, locate the primary node information. Move the mouse pointer over the value of Disk Performance to view the instance's disk performance.
Note:
If no additional I/O performance is configured for your instance, only the base performance is displayed here.
If additional I/O performance is configured for your instance, you can view the base performance, additional performance, and total performance here.
Help and Support
Was this page helpful?
You can also Contact sales or Submit a Ticket for help.
Help us improve! Rate your documentation experience in 5 mins.
Feedback