Huawei Cloud RDS SQLServer

Collect Metrics data from Huawei Cloud RDS SQLServer

Configuration¶

Install Func¶

It is recommended to activate Guance Integration - Extensions - DataFlux Func (Automata): All prerequisites are automatically installed, please continue with the script installation.

If you want to deploy Func manually, refer to Manual Deployment of Func

Install Script¶

Note: Please prepare the Huawei Cloud AK with the required permissions in advance (for simplicity, you can directly grant the global read-only permission Tenant Guest).

Script for Automata Activation¶

1. Log in to the Guance console.
2. Click the 【Integration】 menu, and select 【Cloud Account Management】.
3. Click 【Add Cloud Account】, select 【Huawei Cloud】, and fill in the required information on the interface. If you have already configured the cloud account information before, you can skip this step.
4. Click 【Test】, and after the test is successful, click 【Save】. If the test fails, please check whether the relevant configuration information is correct and retest.
5. Click 【Cloud Account Management】, and you can see the added cloud account in the list. Click the corresponding cloud account to enter the details page.
6. Click the 【Integration】 button on the cloud account details page. Under the Not Installed list, find Huawei Cloud RDS SQLServer, and click the 【Install】 button. The installation interface will pop up, and you can proceed with the installation.

Manual Activation Script¶

1. Log in to the Func console, click 【Script Market】, and enter the Guance script market. Search for integration_huaweicloud_rds_sqlserver.

2. Click 【Install】, and enter the corresponding parameters: Huawei Cloud AK, SK, and account name.

3. Click 【Deploy Startup Script】, and the system will automatically create the Startup script set and configure the corresponding startup script.

4. After activation, you can see the corresponding automatic trigger configuration in 「Management / Automatic Trigger Configuration」. Click 【Execute】 to immediately execute it once without waiting for the scheduled time. After a while, you can check the execution task records and corresponding logs.

Verification¶

1. In 「Management / Automatic Trigger Configuration」, confirm whether the corresponding task has the automatic trigger configuration. You can also check the corresponding task records and logs to see if there are any exceptions.
2. In Guance, go to 「Infrastructure - Resource Catalog」 to see if there is asset information.
3. In Guance, go to 「Metrics」 to see if there is corresponding monitoring data.

Metrics¶

Configure Huawei Cloud RDS SQLServer Metrics. You can collect more Metrics through configuration. Huawei Cloud RDS SQLServer Metrics Details

The performance monitoring Metrics for RDS for SQLServer instances are shown in the following table.

Object¶

The collected Huawei Cloud RDS SQLServer object data structure can be seen in 「Infrastructure - Resource Catalog」.

{
  "measurement": "huaweicloud_rds_sqlserver",
  "tags": {
    "RegionId"               : "cn-south-1",
    "project_id"             : "c631f046252dxxxxxxxf253c62d48585",
    "enterprise_project_id"  : "o78hhbss-xxxx-xxxx-xxxx-cba3d38cf2f9",
    "instance_id"            : "1d0c91561f4644dxxxxxx68304b0520din01",
    "instance_name"          : "rds-xxxx",
    "engine"                 : "SQLServer",
    "type"                   : "Ha",
    "status"                 : "ACTIVE",
  },
  "fields": {
    "port"                   : "3306",
    "security_group_id"      : "9e5bd45e-0564-445f-xxxx-2c8954e2d99c",
    "switch_strategy"        : "xxx",
    "time_zone"              : "China Standard Time",
    "enable_ssl"             : "True",
    "charge_info.charge_mode": "postPaid",
    "engine_version"         : "2022_SE",
    "created_time"           : "2024-11-03T15:26:45+0000",
    "updated_time"           : "2024-11-05T09:58:26+0000",
    "alias"                  : "xxx",
    "private_ips"            : "[\"192.x.x.35\"]",
    "public_ips"             : "[]",
    "datastore"              : "{Instance JSON Data}",
    "cpu"                    : "4",
    "mem"                    : "8",
    "volume"                 : "{volume Information}",
    "nodes"                  : "[{Primary and Standby Instance Information}]",
    "related_instance"       : "[]",
    "backup_strategy"        : "{Backup Strategy}",
    "message"                : "{Instance JSON Data}"
  }
}

Note: The fields in tags and fields may change with subsequent updates.

Tip 1: The value of tags.instance_id is the instance ID, which serves as a unique identifier.

Tip 2: The following fields are all JSON serialized strings.

• fields.message
• fields.private_ips
• fields.public_ips
• fields.volume
• fields.nodes
• fields.related_instance
• fields.backup_strategy

Tip 3: The type value can be "Single", "Ha", "Replica", or "Enterprise", corresponding to single-node instances, primary-standby instances, read-only instances, and distributed instances (Enterprise Edition), respectively.