Huawei Cloud RDS SQLServer

Collect Huawei Cloud RDS SQLServer Metrics data

Configuration¶

Install Func¶

We recommend enabling the Guance integration - extension - DataFlux Func (Automata): all prerequisites are automatically installed, please proceed with script installation.

If you deploy Func on your own, refer to Self-deployed Func

Install Script¶

Note: Please prepare a Huawei Cloud AK that meets the requirements in advance (for simplicity, you can directly grant global read-only permission ReadOnlyAccess).

To synchronize Huawei Cloud RDS SQLServer monitoring data, we install the corresponding collection script: "Guance Integration (Huawei Cloud-RDS-SQLServer Collection)" (ID: guance_huaweicloud_rds_sqlserver)

After clicking 【Install】, input the corresponding parameters: Huawei Cloud AK, Huawei Cloud account name.

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

After the script is installed, find the script "Guance Integration (Huawei Cloud-RDS-SQLServer Collection)" under "Development" in Func, expand and modify this script. Find collector_configs and monitor_configs respectively, and edit the content of region_projects. Change the region and Project ID to the actual region and Project ID, then click Save and Publish.

In addition, you can see the corresponding automatic trigger configuration under "Management / Automatic Trigger Configuration". Click 【Execute】 to immediately execute once without waiting for the scheduled time. Wait a moment, and you can view the execution task records and corresponding logs.

Verification¶

1. In "Management / Automatic Trigger Configuration", confirm whether the corresponding tasks have the corresponding automatic trigger configurations, and at the same time, you can view the corresponding task records and log checks for any abnormalities.
2. On the Guance platform, check whether asset information exists under "Infrastructure - Resource Catalog".
3. On the Guance platform, check whether there are corresponding monitoring data under "Metrics".

Metrics¶

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

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

Objects¶

The collected Huawei Cloud RDS SQLServer object data structure can be seen in the "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"                  : "[{master-slave 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 serialized JSON strings:

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

Tip 3: The value of type is "Single", "Ha", "Replica", or "Enterprise", corresponding to single-instance, master-slave instance, read-only instance, and distributed instance (Enterprise Edition), respectively.