tencent cloud

PrevNext

Feedback

search by keyword

Recent Pages

Documentation
TencentDB for SQL Server
    Documentation
    Download PDF

    Monitoring Metrics

    Last updated: 2024-07-30 16:09:09
    Download PDF
      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.

      Contact Us
      Technical Support

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

      Submit a Ticket
      7x24 Phone Support
      Copyright © 2013-2024 Tencent Cloud. All Rights Reserved.
      Privacy PolicyLegalCookie Policy