This topic describes how to create an RDS for SQL Server instance by using the RDS console.

For information about how to create an RDS for MySQL instance by calling an API action, see CreateDBInstance.

For information about the pricing of RDS for MySQL instances, see Billing methods and billable items.

Prerequisites

You have registered an Alibaba Cloud account. For more information, see Sign up with Alibaba Cloud.

Precautions

  • Subscription instances cannot be converted to pay-as-you-go instances.
  • Pay-as-you-go instances can be converted to subscription instances. For operation instructions, see Switch from pay-as-you-go billing to subscription billing.
  • An Alibaba Cloud account can create up to 30 pay-as-you-go RDS instances. You can open a ticket to apply for increasing the limit.

Procedure

  1. Log on to the RDS console.
  2. On the Instances page, click Create Instance.
  3. Select a billing method:
    • Pay-As-You-Go: indicates post payment (billed by hour). For short-term requirements, create pay-as-you-go instances because they can be released at any time to save costs.
    • Subscription: indicates prepayment. You must pay when creating an instance. For long-term requirements, create subscription instances because they are more cost-effective. Furthermore, the longer the subscription, the higher the discount.
  4. Set the following parameters.
    Parameter Description
    Region Indicates the location of the RDS instance you want to purchase. You cannot change the region once you confirm your order.
    • Select the region closest to your users to increase the access speed.
    • Select the region where your ECS instance is located so that the ECS instance can access the RDS instance through the intranet. If the ECS instance and RDS instance are located in different regions, they can communicate only through the Internet and hence performance is degraded.
    Database Engine

    The supported database engines are MySQL, Microsoft SQL Server, PostgreSQL, PPAS (compatible with Oracle), and MariaDB TX.

    In this example, select Microsoft SQL Server.

    Note The available database engines vary depending on the region you select.
    Version

    For RDS for SQL Server, the supported versions are SQL Server 2017, 2016, 2012, and 2008 R2. For more information, see Functions supported by different editions of SQL Server.

    Note The available versions vary depending on the region you select.
    Edition
    • Basic: This edition provides a single node and separates computing from storage. It is extremely cost-effective.
    • High-availability: This edition adopts the high-availability architecture with one master node and one slave node. It is applicable to over 80% of scenarios.
    • AlwaysOn: This edition provides one master node, one slave node, and up to seven read-only nodes that horizontally scale read capabilities.
    Note The available product series vary depending on the region you select. For more information on the product series, see Product series overview.
    Zone

    A zone is a physical area within a region. Different zones in the same region are basically the same.

    You can deploy the master and slave nodes of your RDS instance in the same zone or in different zones.

    Network Type
    • Classic Network: indicates the traditional network.
    • VPC (recommended): short for Virtual Private Cloud. A VPC is an isolated network environment and therefore provides higher security and performance than the classic network.
      Note Make sure the network type of the RDS instance is the same as that of your ECS instance so that the ECS instance can access the RDS instance through the intranet.
    Type

    Indicates the specifications of the RDS instance. Each instance type supports a specific number of CPU cores, memory size, maximum number of connections, and maximum IOPS. For more information, see Instance types.

    RDS for SQL Server supports the following instance type families:

    • General-purpose instance: owns dedicated memory and I/O resources, but shares CPU and storage resources with the other general-purpose instances on the same server.
    • Dedicated instance: owns dedicated CPU, memory, storage, and I/O resources.
    • Dedicated host: owns all the CPU, memory, storage, and I/O resources on the server where it is located.

    For example, 8 Cores 32 GB (Basic) indicates a general-purpose instance, and 8 Cores 32 GB (Dedicated) indicates a dedicated instance.

    Capacity

    Used for storing data, system files, binlog files, and transaction files.

  5. Set the duration (only for subscription instances) and quantity, and click Buy Now.
    Note For a subscription instance, you can:
    • Select Auto Renew in the Duration section. Then the system can automatically deduct fees from your account to extend the validity period of your instance. For example, if you purchase a three-month subscription instance with Auto Renew selected, the system automatically deducts frees of three months when the instance is about to expire.
    • Click Add to Cart and then click the cart to place the order.
  6. On the Order Confirmation page, review the order information, select the terms and agreements as prompted, click Pay Now, and complete the payment.

What to do next

  1. In the upper left corner of the RDS console, select the region where the instance is located, and view the instance details.
    选择地域
  2. Configure a whitelist.
  3. Create accounts.
  4. Apply for an Internet address (if you want to access the RDS instance through the Internet).
  5. Connect to the RDS instance.

APIs

API Description
CreateDBInstance Used to create an RDS instance.