Huawei Cloud RDS SQLServer

Collect Huawei Cloud RDS SQLServer metric data.

Config¶

Install Func¶

Recommend opening 「Integrations - Extension - DataFlux Func (Automata)」: All preconditions are installed automatically,Please continue with the script installation

If you deploy Func yourself,Refer to Self-Deployment of Func

Recommend deploying GSE (Game Server Engine) edition translation.

Installation script¶

Tip: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 the monitoring data of Huawei Cloud RDS SQLServer, we install the corresponding collection script: 「Guance Cloud Integration (Huawei Cloud RDS-SQLServer Collection)」 (ID: guance_ huaweicloud_rds_sqlserver)

Click 【Install】 and enter the corresponding parameters: HUAWEI CLOUD AK, HUAWEI CLOUD account name.

Tap【Deploy startup Script】, the system automatically creates Startup script sets, and automatically configure the corresponding startup script.

After installing the script, find the script 「Guance Cloud Integration (Huawei Cloud RDS-SQLServer data collection)」 in the 「Development」 section of Func. Expand and modify the script, find collector_configs and monitor_configs, and edit the content in region_projects below. Change the region and Project ID to the actual region and Project ID, and then click save and publish.

In addition, in「Management / Automatic Trigger Configuration」 you can see the corresponding automatic trigger configuration. Click 【Execute】 to run it immediately, without waiting for the scheduled time. After a short moment, you can check the execution task records and corresponding logs.

Verify¶

1. In「Management / Crontab Config」check whether the automatic triggering configuration exists for the corresponding task,In addition, you can view task records and logs to check whether exceptions exist
2. On the guance cloud platform, click 「Infrastructure / Custom」 to check whether asset information exists
3. On the guance cloud platform, press 「Metrics」 to check whether monitoring data exists

Metric¶

Configure Huawei Cloud RDS SQLServer metrics to collect more metrics through configuration Huawei Cloud RDS SQLServer Metric 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 viewed in the 「Infrastructure Customization」section for object data

{
  "measurement": "huaweicloud_rds_sqlserver",
  "tags": {
    "name"                   : "1d0c91561f4644daxxxxx68304b0520din01",
    "id"                     : "1d0c91561f4644dxxxxxx68304b0520din01",
    "instance_name"          : "rds-xxxx",
    "status"                 : "ACTIVE",
    "port"                   : "3306",
    "type"                   : "Ha",
    "RegionId"               : "cn-south-1",
    "security_group_id"      : "9e5bd45e-0564-445f-xxxx-2c8954e2d99c",
    "switch_strategy"        : "xxx",
    "project_id"             : "c631f046252dxxxxxxxf253c62d48585",
    "time_zone"              : "China Standard Time",
    "enable_ssl"             : "True",
    "charge_info.charge_mode": "postPaid",
    "engine"                 : "SQLServer",
    "engine_version"         : "2022_SE"
  },
  "fields": {
    "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 message}",
    "nodes"           : "[{Primary and backup instance information}]",
    "related_instance": "[]",
    "backup_strategy" : "{Backup strategy}",
    "message"         : "{Instance JSON data}"
  }
}

notice：tags、fieldsThe fields in this section may change with subsequent updates

Tips 1：The value of tags.name is the instance ID, which serves as a unique identifier

Tips 2：The following fields are JSON serialized strings

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

Tips 3：The value of type is "Single","Ha" or "Replica","Enterprise",corresponding to single machine instance, primary/backup instance, read-only instance, and distributed instance (Enterprise Edition), respectively.