How do I view the monitoring data of a TencentDB for SQL Server instance?
TencentDB for SQL Server supports 38 common SQL Server parameters. For details, please refer to Supported Monitoring Metrics. You can also use SSMS's counters to additionally track other parameters.
You can view and understand the operational information of instances through Monitoring Charts, and set up Alarm Policies, Alarm Notifications, and View Alarm History for a total of 38 monitoring metrics including CPU, memory, storage, network, connections, access, locks, etc., using TCOP. You can configure alarm settings in TCOP > Alarm Management > Policy Management > Create Policy.
Where can I view monitoring charts in TencentDB for SQL Server?
To make it easier for you to view and stay up to date with how instances work, TencentDB for SQL Server provides a wide variety of performance monitoring metrics and convenient monitoring features (custom view, time comparison, merged monitoring metrics, etc.). You can view instance performance information through Monitoring Charts.
What monitoring metrics are supported by TencentDB for SQL Server?
TencentDB for SQL Server supports 38 common metrics of SQL Server. For more information, see Monitoring Metrics. You can also collect statistics of other metrics by configuring the counters of SSMS.
How do I set an alarm policy for TencentDB for SQL Server?
You can create an alarm policy in the TCOP console to trigger an alarm and send notifications if a monitoring metric of TencentDB for SQL Server becomes abnormal. For more information, see Setting Alarm Policies.
How do I associate an alarm policy with an alarm object in TencentDB for SQL Server?
You can create an alarm policy and associate it with an alarm object in the TCOP console. If the object meets the alarm trigger condition, an alarm will be triggered. For more information, see Setting Alarm Policies.
How do I set alarm notifications for TencentDB for SQL Server?
After creating an alarm policy, you can configure an alarm notification template and alarm notifications in the TCOP console. If an exception triggers an alarm, the system will send notifications to the recipients via your specified channels (email, SMS, WeChat, WeCom, telephone). For more information, see Setting Alarm Notifications.
How do I view alarm records in TencentDB for SQL Server?
You can view detailed alarm records in the console and quickly locate specific problems through alarm messages for further troubleshooting. For more information, see Viewing Alarm Records.
What is the minimum monitoring granularity in TencentDB for SQL Server?
The minimum monitoring granularity in TencentDB for SQL Server is 10 seconds, and the time range automatically changes with the granularity.
Which monitoring metrics of a TencentDB for SQL Server instance should I stay up to date with?
Key monitoring metrics to pay attention to include: CPU utilization, memory usage, and percentage of remaining disk capacity. Alarm alerts can be configured based on actual application scenarios, so when TencentDB for SQL Server monitoring metrics show abnormal states, alarms are triggered and relevant notifications are sent. Upon receiving an alarm, appropriate measures should be taken to clear the alert. For details, please see Setting Alarm Policies.
Configuration example: If, over a certain period (e.g., 5min), the CPU utilization exceeds a specific value (e.g., 80%) multiple times (e.g., 5 times), an alarm is triggered (e.g., once every hour).