Contents：
- What is the architecture of TencentDB for SQL Server like?
- How do I create a TencentDB for SQL Server instance and connecting to a database?
- How do I manage the account of a TencentDB for SQL Server instance?
- How do I monitor a TencentDB for SQL Server instance?
- How do I roll back a TencentDB for SQL Server instance?
- How do I back up a TencentDB for SQL Server instance?
- How do I migrate data to TencentDB for SQL Server?
- How do I upgrade a TencentDB for SQL Server instance?
What is the architecture of TencentDB for SQL Server like?
TencentDB for SQL Server consists of a master database and a mirror database that are deployed in different racks. Each database corresponds to a group of monitoring agents which monitor the database in real time based on the heartbeat. The cluster management scheduling center consists of two sets of independently deployed decision-making clusters and configuration clusters and is mainly used to manage the normal operations of the database node group, access gateway cluster and HDFS. The Hadoop distributed file system (HDFS) makes available data disaster recovery service with cold backup. The gateway cluster is accessed to provide a unique IP, and if the data node is switched, the IP won't change.
How do I create a TencentDB for SQL Server instance and connecting to a database?
You can manage the database in the TencentDB for SQL Server Console.
How do I manage the account of a TencentDB for SQL Server instance?
TencentDB for SQL Server do not allow the creation/deletion of databases and creating/deleting/modifying accounts via Microsoft SQL Server Management. You can go to TencentDB for SQL Server Console > Instance Details page > Account Management to create, delete, an account or modify account permission.
Currently, the console only allows you to use the "read-write" and "read-only" permissions. If you need permissions at a higher level, please submit a ticket for application (no sa account is provided).
How do I monitor a TencentDB for SQL Server instance?
TencentDB for SQL Server supports 25 common parameters of SQL Server. You can collect statistics of other parameters by configuring the counters of SSMS. For more information, see Monitoring and Alarming.
Currently, alarming is supported for the following metrics through Cloud Monitor. You can configure alarms in Cloud Monitor Console > Alarm Configuration > Alarm Policy.
- CPU utilization
- Connection count
- TrafficIn
- TrafficOut
- IOPS
- Storage capacity
How do I roll back a TencentDB for SQL Server instance?
The full and log backups in TencentDB for SQL Server are retained for seven days; therefore, you can roll back to any time point within the past seven days.
How do I back up a TencentDB for SQL Server instance?
In the TencentDB for SQL Server Console, you can restore the database to another instance (such as a self-built instance) using a downloaded backup file.
How do I migrate data to TencentDB for SQL Server?
TencentDB for SQL Server supports migrating data from an SQL Server instance created by CVM or COS.
How do I upgrade a TencentDB for SQL Server instance?
Upgrade means upgrading an existing TencentDB for SQL Server instance to a higher specification.
- Select an instance in the TencentDB for SQL Server Console and click Upgrade in the Operation column.
- On the upgrade page that pops up, select the desired specification based on your needs and make the payment. Once payment is completed, the system will automatically upgrade the instance specification.
Upgrade fee = (price of target specification - price of original specification) x remaining validity period
- You can only upgrade an instance to a higher specification. Downgrade is not supported.
- You cannot cancel the upgrade process once it has started.
