tencent cloud

Feedback

Monitoring Metrics

Last updated: 2024-07-30 16:09:09
    This document describes the common monitoring metrics supported by TencentDB for SQL Server.

    Monitoring Metrics

    TencentDB for SQL Server supports monitoring 43 common metrics of SQL Server. You can collect statistics of other metrics by configuring the performance counters of SQL Server Management Studio (SSMS).
    Note:
    To view monitoring metrics at the system level, contact us.
    Classification
    Metric Name
    Unit
    Descriptions
    CPU
    CPU Usage
    %
    Percentage of actual CPU consumption
    Note:
    When the user's business QPS is less than 5 or there is no business database, the CPU will be displayed as 0.
    For instances with cloud disk architecture, the CPU metrics are collected from the CPU of the machine where the instance is deployed. In cases of smaller specifications (such as 2C or 4C), there may be some fluctuations.
    Memory
    Memory Usage
    MB
    Total memory usage
    Max Memory
    KB
    Max memory
    Memory Usage Rate
    %
    Memory usage rate
    Internal System Locked Memory
    KBytes
    Internal system locked memory
    This monitoring metric can be viewed only in 2014 and later versions.
    
    Internal System Consumed Memory
    KBytes
    Internal system consumed memory
    This monitoring metric can be viewed only in 2014 and later versions.
    
    Storage
    Disk Throughput
    KBytes/s
    The total size of data written and read to the disk per second (for monitoring machines deployed with dual node cloud disk instances)
    Disk Read Traffic
    KBytes/s
    Amount of data read from disk to memory per second (for monitoring machines deployed with dual node cloud disk instances)
    Disk Write Traffic
    KBytes/s
    Amount of data written from memory to disk per second (for monitoring machines deployed with dual node cloud disk instances)
    Disk IOPS
    Times/sec
    Number of disk read and write times
    Number of Disk Read Times
    Times/sec
    Number of disk read times per second
    Number of Disk Write Times
    Times/sec
    Number of disk write times per second
    Used Storage
    GB
    Sum of storage space consumed by instance database files and log files
    Remaining Storage Space
    %
    Percentage of remaining hard disk capacity, calculated as: (Purchased disk - Used storage space) / Purchased disk
    Read IO Average Response Time
    ms
    The average time required to read data from the disk, measured in seconds, for monitoring the machines deployed with two-node cloud disk instances and system-level monitoring of machines deployed with two-node local disk instances.
    Write IO Average Response Time
    ms
    The average time required to write data to the disk, measured in seconds, for monitoring the machines deployed with two-node cloud disk instances and system-level monitoring of machines deployed with two-node local disk instances.
    IO Request Average Response Time
    ms
    Average response time per IO request (for system-level monitoring of machines deployed with dual node local disk instances)
    Number of Read IOs Per Second on Disk
    Times/sec
    Number of read IOs per second on disk (for system-level monitoring of machines deployed with dual node local disk instances)
    Number of Write IOs Per Second on Disk
    Times/sec
    Number of write IOs per second on disk (for system-level monitoring of machines deployed with dual-node local disk instances)
    Total Disk IOPS
    Times/sec
    Total IOPS on disk (for system-level monitoring of machines deployed with dual-node local disk instances)
    Disk Queue Length
    Count
    Disk queue length (for system-level monitoring of machines deployed with dual-node local disk instances)
    Network
    Inbound Traffic
    KB/s
    Sum of inbound packet sizes for all connections
    Outbound Traffic
    KB/s
    Sum of outbound packet sizes for all connections
    Average Network I/O Delay
    ms
    Average network I/O delay time
    RO Sync Delay Time
    Sec
    Data sync delay time between primary instances and read-only instances
    Connection
    Number of Connections
    Connections
    Average number of databases connected by users per second
    Number of Logins Per Second
    Times/sec
    Number of logins per second
    Number of Logouts Per Second
    Times/sec
    Number of logouts per second
    Access
    Slow Queries
    Queries
    Number of queries running longer than one second
    Number of Requests
    Times/sec
    Average number of requests per second
    Number of SQL Compilations
    Times/sec
    Average number of SQL compilations per second
    Number of SQL Recompilations
    Times/sec
    Average number of SQL recompilations per second
    Number of Full-Table Scans for SQL Per Second
    Times/sec
    Number of full-table scans for SQL per second
    Number of Transactions
    Times/sec
    Average number of transactions per second
    Number of Blockings
    Blockings
    Number of current blockings
    Execution Cache Hit Rate
    %
    Each SQL statement has an execution plan, the hit rate of the execution plan.
    Buffer Cache Hit Rate
    %
    Data cache (memory) hit rate
    Lock
    Number of Lock Requests
    Times/sec
    Average number of lock requests per second
    Number of Latch Waits Per Second
    Times/sec
    Number of latch waits per second
    Average Latency on a Lock Wait
    Ms
    Average wait time of each lock request resulting in wait
    Number of Deadlocks
    Number/sec
    Number of lock requests causing deadlocks per second
    Blocking Report Generation Threshold
    Minute
    The specified threshold for generating blocking reports. If the threshold is exceeded, a blocked process report will be generated. By default, blocking process reports are not generated.
    Others
    Number of User Errors
    Times/sec
    Average number of errors per second
    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