Alibaba Cloud RDS SQLServer¶

Alibaba Cloud RDS SQLServer Metrics display, including CPU usage, memory usage, IOPS, network bandwidth, InnoDB, TPS, QPS, etc.

Configuration¶

Install Func¶

It is recommended to enable TrueWatch integration - expansion - managed Func: all prerequisites are automatically installed. Please continue with the script installation.

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

It is recommended to deploy the GSE version.

Installation Script¶

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

To synchronize monitoring data of RDS cloud resources, we install the corresponding collection script: "TrueWatch Integration (Alibaba Cloud - RDS Collection)" (ID: truewatch_aliyun_rds)

After clicking [Install], enter the corresponding parameters: Alibaba Cloud AK, Alibaba Cloud account name.

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

In addition, you can see the corresponding automatic trigger configuration in "Management / Automatic Trigger Configuration". Click [Execute] to immediately execute once without waiting for the scheduled time. After a short wait, you can view the execution task records and corresponding logs.

We default to collecting some configurations, details are listed under metrics.

Configure custom cloud object metrics

Verification¶

1. In "Management / Automatic Trigger Configuration", confirm whether the corresponding task has an automatic trigger configuration, and you can also check the corresponding task records and logs for any abnormalities.
2. On the TrueWatch platform, in "Infrastructure / Custom", check if there is asset information.
3. On the TrueWatch platform, in "Metrics", check if there is corresponding monitoring data.

Metrics¶

After configuring Alibaba Cloud - Cloud Monitoring, the default metric sets are as follows. You can collect more metrics through configuration. Alibaba Cloud Cloud Monitoring Metric Details

Objects¶

The collected Alibaba Cloud RDS object data structure can be seen from "Infrastructure - Custom".

{
  "measurement": "aliyun_rds",
  "tags": {
    "name": "rm-xxxxx",
    "DBInstanceType": "Primary",
    "PayType": "Prepaid",
    "Engine": "MySQL",
    "DBInstanceClass": "rds.mysql.s2.large",
    "DBInstanceId": "rm-xxxxx",
    "ZoneId": "cn-shanghai-h",
    "RegionId": "cn-shanghai",
    "DBInstanceDescription": "Business System",
    "LockMode": "Unlock",
    "Category": "Basic",
    "ConnectionMode": "Standard",
    "DBInstanceNetType": "Intranet",
    "DBInstanceStorageType": "local_ssd"
  },
  "fields": {
    "CreationTime": "2022-12-13T16:00:00Z",
    "ExpireTime": "2022-12-13T16:00:00Z",
    "DiskUsed": "10000",
    "BackupSize": "10000",
    "LogSize": "10000",
    "BackupLogSize": "10000",
    "BackupDataSize": "10000",
    "ConnectionString": "{JSON connection address data}",
    "DBInstanceStorage": "100",
    "accounts": "{JSON user privilege data}",
    "databases": "{JSON database data}",
    "SSLExpireTime": "2022-10-11T08:16:43Z",
    "message": "{JSON instance data}"
  }
}

Logs¶

Slow Query Statistics¶

Prerequisites for Slow Query Statistics¶

Note 1: The code execution of this script depends on the RDS instance object collection. If the custom object collection for RDS is not configured, the slow log script cannot collect slow log data. Note 2: Due to the delay of 6~8 hours in returning statistics data from Alibaba Cloud, the collector updating data may have delays. Refer to the Alibaba Cloud documentation: Cloud Database RDS Slow Log Statistics for detailed information. Note 3: This collector supports all versions of MySQL (excluding the basic edition of MySQL 5.7), SQL Server 2008 R2, MariaDB 10.3 type databases. To collect other types of databases, use the Alibaba Cloud - RDS Slow Query Detail collector.

Slow Query Statistics Installation Script¶

On top of the previous setup, you need to install another script for RDS Slow Query Statistics Log Collection.

In "Management / Script Market", click and install the corresponding script package:

• "TrueWatch Integration (Alibaba Cloud - RDS Slow Query Statistics Log Collection)" (ID: truewatch_aliyun_rds_slowlog)

After the data synchronization is normal, you can view the data in the "Logs" section of TrueWatch.

An example of the reported data is as follows:

{
  "measurement": "aliyun_rds_slowlog",
  "tags": {
    "name": "rm-xxxxx",
    "DBName": "cloudcare_core",
    "DBInstanceId": "rm-bp1xxxxxxxxxx",
    "RegionId": "cn-hangzhou",
    "DBInstanceType": "Primary",
    "PayType": "Prepaid",
    "Engine": "MySQL",
    "DBInstanceClass": "rds.mysql.s2.large",
    "ZoneId": "cn-shanghai-h",
    "DBInstanceDescription": "Business System"
  },
  "fields": {
    "SQLHASH": "436f9dd030e0a87920bbcd818b34f271",
    "SQLText": "{SQL Statement}",
    "CreateTime": "2022-06-05Z",
    "SQLServerTotalExecutionTimes": 0,
    "MaxExecutionTime": 1,
    "MaxLockTime": 0,
    "AvgExecutionTime": 0,
    "MySQLTotalExecutionTimes": 0,
    "SQLServerTotalExecutionTimes": 1,
    "SQLServerTotalExecutionCounts": 0,
    "MySQLTotalExecutionCounts": 0,
    "SQLServerAvgExecutionTime": 0,
    "message": "{Log JSON Data}"
  }
}

Descriptions of some parameters are as follows:

Note: Fields such as AvgExecutionTime, SQLServerAvgExecutionTime, SQLServerTotalExecutionTimes, etc., are only supported by SQL Server instances. > Note: Fields in tags and fields may change with subsequent updates.

Slow Query Details¶

Prerequisites for Slow Query Details¶

Note: The code execution of this script depends on the RDS instance object collection. If the custom object collection for RDS is not configured, the slow log script cannot collect slow log data.

Slow Query Details Installation Script¶

On top of the previous setup, you need to install another script for RDS Slow Query Details Log Collection.

In "Management / Script Market", click and install the corresponding script package:

• "TrueWatch Integration (Alibaba Cloud - RDS Slow Query Details Log Collection)" (ID: truewatch_aliyun_rds_slowlog_record)

After the data synchronization is normal, you can view the data in the "Logs" section of TrueWatch.

Configuration Cloud Database RDS Slow Query Details

An example of the reported data is as follows:

{
  "measurement": "aliyun_rds_slowlog",
  "tags": {
    "name": "rm-xxxxx",
    "DBName": "cloudcare_core",
    "DBInstanceId": "rm-bp1xxxxxxxxxx",
    "RegionId": "cn-hangzhou",
    "DBInstanceType": "Primary",
    "PayType": "Prepaid",
    "Engine": "MySQL",
    "DBInstanceClass": "rds.mysql.s2.large",
    "ZoneId": "cn-shanghai-h",
    "DBInstanceDescription": "Business System",
    "HostAddress": "xxxx",
    "UserName": "xxxx",
    "ClientHostName": "xxxx",
    "ApplicationName": "xxxx"
  },
  "fields": {
    "SQLHASH": "436f9dd030e0a87920bbcd818b34f271",
    "SQLText": "{SQL Statement}",
    "QueryTimes": 0,
    "QueryTimesMS": 0,
    "ReturnRowCounts": 0,
    "ParseRowCounts": 0,
    "ExecutionStartTime": "2022-02-02T12:00:00Z",
    "CpuTime": 1,
    "RowsAffectedCount": 0,
    "LastRowsAffectedCount": 0,
    "message": "{Log JSON Data}"
  }
}

Descriptions of some parameters are as follows:

Note: Fields such as CpuTime, RowsAffectedCount, LastRowsAffectedCount are only supported by SQL Server instances. > Note: Fields in tags and fields may change with subsequent updates. > *Note: fields.message is a JSON serialized string.