Scenarios
This document describes how to create an instance through the TencentDB for SQL Server console.
Prerequisites
Operation Steps
Instance creation
1. Log in to the TencentDB for SQL Server purchase page. Complete the following steps in order: Select a basic configuration, Set network and database, and Confirm the configuration info. Read and agree to the service terms. After verifying that everything is correct, click Buy Now. Step 1. Select a basic configuration
In this step, you can configure the basic and specification settings for the instance. The specific configurable items are as follows:
Basic Configuration
Billing Mode: pay-as-you-go.
Region: Select the region for instance deployment. To reduce access latency and improve download speed, we recommend that you choose the region closest to your customers.
AZ: Select an AZ within the chosen region. You can also choose a random AZ, in which case the system will assign one randomly.
Instance Architecture: Support single-node, two-node, and multi-node.
Storage Type:
When the single-node architecture is selected, you can choose from the following storage types: High-Performance Cloud Disk, SSD Cloud Disk, Balanced SSD Cloud Disk, and Enhanced SSD Cloud Disk.
Note:
For single-node instances in Mainland China regions that require SSD CBS, please submit a ticket to apply. When the two-node architecture is selected, the storage type supports Enhanced SSD, Balanced SSD, and High-Performance Local SSD.
When the multi-node architecture is selected, the storage type supports Enhanced SSD and Balanced SSD.
For details of each storage type and use cases, see Storage Types. Database Versions: Support SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019 Enterprise/Standard, and SQL Server 2022 Enterprise. You can view database versions supported for different instance architectures on the purchase page.
Disk encryption: For instances located in Shanghai, with storage type of Cloud Block Storage (CBS) and database version of SQL Server 2019/2022 Enterprise, the disk encryption feature can be used after applying for whitelisting. This feature is not supported in other regions or for other versions. If you need to use this feature, submit a ticket for application. The disk encryption field will only be displayed after you apply for disk encryption. Key source: This item is displayed when disk encryption is enabled. Currently, the default key source is provided by Tencent Cloud.
Number of replica nodes: If the multi-node architecture is selected, you need to specify the number of replica nodes with the number range from 2 to 5. The settings are not required for single-node or two-node architecture.
Multi-AZ deployment: This option is available when a two-node or multi-node architecture is selected. For multi-node architecture, it can only be set to enabled.
Enabled: Multi-AZ deployment is enabled, requiring the selection of secondary AZs in the next step. Each secondary node can be assigned a secondary AZ. Note: If all secondary nodes are deployed in the same AZ, the AZ-level disaster recovery is not supported. Please choose different secondary AZs.
Disabled: Multi-AZ deployment is not enabled. Currently, only Shanghai, Beijing, Guangzhou, and Hong Kong (China) support multi-AZ deployment. Multi-AZ is a physical zone that combines multiple single AZs in the same region, which is used to protect databases in case of instance faults or AZ interruptions.
Secondary AZ: If multi-AZ deployment is enabled, select the secondary AZs based on the available resources.
Specs Configuration
Type: Dedicated.
Filter: Quickly filter the CPU and memory of the required instances. All CPUs and all memory are selected by default.
Selected instances: Displays the specifications of the selected instances, including the specification type and details.
Instance specifications: Displays the instance's specification type, CPU, memory, maximum IOPS, supported AZs, and rule-based reference fees.
Storage space: Select the required disk capacity.
Step 2. Set network and database
Network: Supports VPC. For connectivity testing, see Network Environment. Both VPC networks and subnets support fuzzy search. Note:
It is recommended that the CVM and the cloud database reside under the same account and within the same VPC (to ensure they are in the same region, with no restriction on AZs).
A subnet is a network space within a VPC and is a logical concept. You can create subnets in different AZs under the same VPC. Subnets in different AZs under the same VPC can communicate over the private network by default. Even if you select a subnet in another AZ within the same region, the actual service connection follows a proximity-based logic and does not increase network latency.
Security group: A stateful virtual firewall with filtering capabilities, used to configure network access control for single or multiple cloud databases. It is an important network security isolation mechanism provided by Tencent Cloud.
Note:
It supports creating new security groups or selecting existing ones, and it also supports multi-selection and fuzzy search.
Instance name: You can name the instance immediately or after creation.
System time zone: China Standard Time (Beijing Time) is supported by default.
If you purchase a two-node local disk instance, you must first submit a ticket to apply for system time zone modifications. If you purchase a single-node cloud disk, a two-node cloud disk, or a multi-node cloud disk instance, you can directly modify the system time zone on the purchase page with no need for an application.
Collation rule: The instance character set provides collation rules for system data, which define case-sensitivity and accent-sensitivity attributes. Chinese_PRC_CI_AS is supported by default.
If you purchase a two-node local disk instance, you must first submit a ticket to apply for character set rule modifications. If you purchase a single-node cloud disk, a two-node cloud disk, or a multi-node cloud disk instance, you can directly modify the system time zone on the purchase page with no need for an application.
Project: TencentDB for SQL Server supports assigning instances to different projects for management. It also supports fuzzy search of project names for faster project selection.
Tag: It facilitates the categorized management of instance resources. It also supports adding multiple tags.
Maintenance window and maintenance time: To ensure the stability of TencentDB for SQL Server instances, the backend system performs maintenance operations on instances irregularly within the maintenance window. It is recommended that you configure an acceptable maintenance time for your business instances, typically during off-peak hours, to minimize the impact on your business. Up to 7 maintenance cycles can be selected.
Step 3. Confirm the configuration info
Display the configuration details of instances in step one and step two. If modifications are needed, click Edit. After all settings are confirmed, enable auto-renewal, read and agree to terms of the service, and click Purchase Now.
Auto-renewal (for monthly subscription billing mode): If auto-renewal is enabled and the account balance is sufficient, the instance will be automatically renewed upon expiration based on the selected purchase duration: monthly or annually.
Purchase duration of 1 to 11 months: The auto-renewal period is one month, and the instance will be automatically renewed on a monthly basis upon expiration.
Purchase duration of 1 to 5 years: The auto-renewal period is one year, and the instance will be automatically renewed on a yearly basis upon expiration, with an auto-renewal discount applied.
2. After purchase, return to the Instance List to view the created instance. When the running status is displayed as Running, it indicates that the instance has been created successfully. 1. On the Instance List page, click the Instance ID or Manage in the Operation column to go to the instance management page. 2. On the instance management page, select Account Management > Create Account, enter relevant information in the pop-up dialog box, and then click OK after confirmation.
Note:
This account name and password are used to connect to the SQL Server cloud database. Please keep them secure.
Creating a Database
1. On the Instance List page, click the Instance ID or Manage in the Operation column to go to the instance management page. 2. On the instance management page, choose Database Management > Create Database, enter relevant information in the pop-up dialog box, and then click OK after confirmation.
Database name: It must consist of letters, digits, and underscores, start with a letter, and be at most 32 characters long.
Supported character set: Select the character set used by the database. Most native character sets are currently supported.
Authorize account: You can grant permissions to existing accounts for this database. If no account has been created, see Account Creation. Remarks: Enter remarks, which can be up to 256 characters.
Related APIs
|
| This API is used to create a highly available instance (local disk). |
| This API is used to create a Basic Edition instance (cloud disk). |
| This API is used to create a highly available instance (cloud disk). |
| This API (DescribeRegions) is used to query region information for sale. |
| This API (DescribeZones) is used to query currently available AZ information for sale. |
| This API (DescribeProductConfig) is used to query product configuration for sale. |
| This API (DescribeSpecSellStatus) is used to query the status information of specifications for sale, including the sales status and reference price. (The actual price is subject to the result returned by price querying APIs.) |
| This API (InquiryPriceCreateDBInstances) is used to query the price for applying for an instance. |
| This API (DescribeOrders) is used to query order information. |
| This API (DescribeInstanceByOrders) is used to query the resource ID based on the order number. |