Overview

Billing

Yearly/monthly and pay-per-use billing modes are available.

• Yearly/Monthly: A prepaid billing mode where you pay for resources before using it. Bills are settled based on the subscription period. The longer your subscription term is, the better your discount is. This mode is a good option for long-term, stable workloads.
• Pay-per-use: A postpaid billing mode. You pay as you go and just pay for what you use. The DB instance usage is calculated by the second but billed every hour. This mode allows you to adjust resource usage easily. You do not need to prepare resources in advance, and you never end up with excessive or insufficient resources.
• You can switch between the yearly/monthly and pay-per-use modes.

Connecting to a DB Instance

You can connect to an RDS for SQL Server instance through Data Admin Service (DAS), a private network, or a public network.

• Through DAS: DAS is a professional database administration service. It enables you to connect to and manage DB instances with ease using a web-based console. The permission required for remotely connecting to DB instances has been enabled for you by default. Using DAS to connect to your DB instance is recommended. It is generally the most secure and convenient option.
• Through a private network: The system assigns a floating IP address to your instance by default. If your application is deployed on an ECS that is in the same region and VPC as your DB instance, you are advised to use a floating IP address to connect to the DB instance from the ECS.
• Through a public network: If you cannot access a DB instance through a floating IP address, bind an EIP to the DB instance and connect it through the EIP.

For more information, see RDS for SQL Server Instance Connection.

Data Migration

DRS is recommended because it is a reliable, efficient, easy-to-use cloud service for migrating data online. It simplifies data transfer while lowering expenses. For more information, see Migration Solution Overview.

Resetting the Administrator Password

If you forget the password of your administrator account when using RDS, you can reset it. If an error occurs on the rdsuser account, for example, if your rdsuser account credentials are lost or deleted, you can restore the rdsuser access by resetting the password. For more information, see Resetting the Administrator Password.

Enabling Public Network Access

You can bind an EIP to an RDS for SQL Server instance for public access or unbind the EIP from an instance as required.

• You can bind an EIP only to a primary DB instance or a read replica.
• If a DB instance already has an EIP bound, you must unbind the EIP from the instance first before binding a new EIP to it.

For more information, see Binding and Unbinding an EIP.

Scaling Up Storage Space

You can scale up storage space if it is no longer sufficient for your workloads. If the DB instance status is Storage full and data cannot be written to databases, you need to scale up the storage. Workloads are not interrupted during storage scale-up. For more information, see Scaling Up Storage Space.

Changing Instance Class

You can change the instance class (vCPUs and memory) of an instance if needed. For more information, see Changing a DB Instance Class.

Data Backup

RDS for SQL Server offers various backup types. To learn about their concepts and differences, see Backup Solutions.

A backup file is generated each time a backup is complete. If the instance fails or data is damaged, you can use the backup to restore the instance, ensuring data availability.

Data Restoration

You can use an automated or manual backup to restore a DB instance to the status when the backup was created. For more information, see Restoration Solutions.

Parameter Templates

You can use database parameter templates to manage DB engine configurations. A database parameter template acts as a container for engine configuration values that can be applied to one or more DB instances.

When creating a DB instance, you can associate a default or custom parameter template with it. After the DB instance is created, you can also change its parameter template if needed.

• Default parameter template

  Each default parameter template contains database engine defaults and database system defaults.

• Custom parameter template

  If you want to use your custom parameter settings, you can create a parameter template and apply it with your DB instance.

For more information, see Managing Parameter Templates.

Publications and Subscriptions

RDS for SQL Server provides publications and subscriptions. This function uses the replication technology to split data reads and writes as well as synchronize data between cloud databases and between cloud databases and on-premises databases. For more information, see Creating a Publication.

DBA Assistant

DBA Assistant provides you with a range of database O&M functions, making it easy to diagnose database problems, locate faults, analyze and optimize database performance. For more information, see Problem Diagnosis and SQL Analysis.

Logs

• System logs contain logs generated while the database is running. They can help you analyze database problems.
• SQL Audit records major change operations on services, databases, and tables in log files for future query and download.
• Slow query logs record statements that exceed the long_query_time value (1 second by default). You can view log details to identify statements that are executing slowly and optimize the statements.

For more information, see Log Management.

API

RDS supports v3 APIs. You can call RDS APIs to perform a range of operations, such as DB instance creation and deletion, backup and restoration, and parameter query and modifications. For more information, see API Reference.

SDK

Using SDKs provided by RDS, you can easily call RDS APIs to set up Internet applications on Huawei Cloud. Java, Python, and Go languages are supported. For more information, see SDK Developer Guide.