Huawei Cloud RDS SQLServer

Collect Huawei Cloud RDS SQLServer Metrics

Configuration¶

Install Func¶

It is recommended to activate the TrueWatch Integration - Extensions - DataFlux Func (Automata): All prerequisites are automatically installed. Please proceed with the script installation.

If you are deploying Func yourself, refer to Self-deploying Func

Install Script¶

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

1. Log in to the Func console, click 【Script Market】, and enter the TrueWatch Script Market. Search for ID: integration_huaweicloud_rds_sqlserver.

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

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

4. After enabling, you can see the corresponding automatic trigger configuration in 「Manage / 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 「Manage / Automatic Trigger Configuration」, confirm whether the corresponding task has the automatic trigger configuration. You can also check the task records and logs for any exceptions.
2. In TrueWatch, check if the asset information exists in 「Infrastructure - Resource Catalog」.
3. In TrueWatch, check if there are corresponding monitoring data in 「Metrics」.

Metrics¶

Configure Huawei Cloud RDS SQLServer Metrics. You can collect more metrics by configuring Huawei Cloud RDS SQLServer Metrics Details

RDS for SQLServer instance performance monitoring metrics are shown in the table below.

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.

Note 1: The value of tags.instance_id is the instance ID, used as a unique identifier.

Note 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

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