tencent cloud

Feedback

Viewing Monitoring Charts

Last updated: 2022-06-06 11:17:12

    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.).

    This document describes how to view monitoring chart info in the console.

    Note:

    If the number of tables in a single instance exceeds one million, database monitoring may be affected. Make sure that the number of tables in a single instance is below one million.

    Types of Instances for Monitoring

    TencentDB for SQL Server primary and read-only instances can be monitored, and each instance is provided with a separate monitoring view for easy query.

    Viewing monitoring data

    1. Log in to the TencentDB for SQL Server console.
    2. Select the region at the top, find the target instance, and click the target instance ID or Manage in the Operation column to enter the instance management page.
    3. On the instance management page, select the System monitoring page to view monitoring metrics.
      Note:

      On the instance list, you can also click the monitoring icon of the target instance to quickly view its monitoring status.

    Displaying Chart in Full Screen

    You can display a single metric in full screen for a clearer preview of metric data.
    1, On System Monitoring} page, you can click icon on the right of the corresponding metric to display the metric in full screen.
    After the preview data is displayed in full screen, you can click the X in the upper right corner to close the full screen display window.

    Exporting Data

    You can export the desired metric data individually.
    On System Monitoring} page, you can click icon on the right of the corresponding metric to export data or pictures of the metric to the local system.

    Selecting Monitoring Time Range

    You can select or customize a time range to query the monitoring over this time period.

    1. On [System Monitoring] page, click the time box.
    2. In the pop-up window, you can select 5 minutes, 30 minutes, 1 hour, 3 hours, 12 hours, 24 hours, 2 days, 7 days, 30 days, today, yesterday, the start and end date, or the time range of them, then click OK.

    Adding Time Comparison

    You can compare monitoring data from multiple time ranges by adding time comparisons.

    1. On [System Monitoring] page, click Add Time icon behind time box.
    2. Select Week-over-Week (Last Week), Day-over-Day (Yesterday), or Custom Date from the drop-down list, and click Ok.

    Monitoring Granularity

    You can view instance monitoring at different time granularities within the selected time period.
    On [System Monitoring] page, select the time period, and then you can select the desired time granularity in the drop-down list after Time Granularity to view the monitoring data.

    Time Periods and Corresponding Chart Granularities

    Time period Time granularity
    5 minutes 10 seconds, 1 minute
    30 minutes, 1 hour 10 seconds, 1 minute, 5 minutes
    3 hours 10 seconds, 1 minute, 5 minutes, 1 hour
    12 hours, today, yesterday 1 minute, 5 minutes, 1 hour
    24 hours, 2 days 1 minute, 5 minutes, 1 hour, 24 hours
    7 days, 30 days 1 hour, 24 hours

    Setting Refresh Time

    You can set the refresh time on the system monitoring page (disabled by default) to observe changes of instance monitoring in real time.
    On System Monitoring} page, click the drop-down button after to set time frequency of data refresh (30 seconds, 5 minutes, 30 minutes, and 1 hour are supported.).

    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support