All Products
Search
Document Center

ApsaraDB RDS:View standard monitoring information

Last Updated:Jul 08, 2024

ApsaraDB RDS for SQL Server provides a variety of performance metrics. You can view the standard monitoring data of an ApsaraDB RDS for SQL Server instance in the ApsaraDB RDS console. The standard monitoring data includes SQL Server processes, database metrics, and basic monitoring data.

Note

Database Autonomy Service (DAS) provides intelligent monitoring, diagnostics, and optimization features. For more information, see Overview of DAS.

Procedure

  1. Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.
  2. In the left-side navigation pane, click Monitoring and Alerts.

  3. On the Standard Monitoring tab, click Standard Monitoring and select a time range to view the related metrics. The following table describes the metrics.

    SQL Server Service Process

    Section

    Metric

    Unit

    Description

    SQL Server CPU Utilization

    sqlserver.cpu_usage

    Per Second

    The CPU utilization of the RDS instance within the operating system.

    IOPS

    sqlserver.db_io_read

    Per Second

    The number of read I/O requests per second.

    sqlserver.db_io

    Per Second

    The number of I/O requests per second.

    sqlserver.db_io_write

    Per Second

    The number of write I/O requests per second.

    Instance Space

    sqlserver.log_size

    MByte

    The amount of disk space occupied by log files.

    sqlserver.ins_size

    MByte

    The total amount of disk space occupied by the RDS instance.

    sqlserver.tmp_size

    MByte

    The amount of disk space occupied by temporary files.

    sqlserver.data_size

    MByte

    The amount of disk space occupied by data files.

    sqlserver.other_size

    MByte

    The amount of disk space occupied by system files.

    SQLServer_DetailedSpaceUsage.disk_dump

    MByte

    The amount of disk space occupied by the dump files generated when SQL Server errors occur.

    SQLServer_DetailedSpaceUsage.disk_errorlog

    MByte

    The amount of disk space occupied by error log files. You can delete the error logs of an RDS instance in the ApsaraDB RDS console or by calling an API operation. For more information, see Clean up error logs.

    SQLServer_DetailedSpaceUsage.disk_mastersize

    MByte

    The amount of disk space that is used to store data in the master system database.

    SQLServer_DetailedSpaceUsage.disk_modelsize

    MByte

    The amount of disk space that is used to store data in the model database. The model database is the template for new databases.

    SQLServer_DetailedSpaceUsage.disk_msdbsize

    MByte

    The amount of disk space that is used to store data in the msdb database. The msdb database is used to manage jobs of SQL Server Agent and the backup history.

    SQLServer_DetailedSpaceUsage.disk_trace

    MByte

    The amount of disk space that is used to store SQL Server trace files such as files obtained by using SQL Server Profiler.

    SQLServer_DetailedSpaceUsage.disk_xel

    MByte

    The amount of disk space occupied by log files of extension point events.

    Database metrics

    Section

    Metric

    Unit

    Description

    QPS

    sqlserver.qps

    Per Second

    The average number of times that SQL statements are executed per second.

    The total number of connections.

    sqlserver.connection_reset

    Count

    The total number of logon attempts from the connection pool per second.

    sqlserver.active_temp_tables

    Count

    The number of active temporary tables.

    sqlserver.active_session

    Count

    The number of active threads.

    sqlserver.active_cursors

    Count

    The number of active cursors.

    sqlserver.sessions

    Count

    The total number of current connections.

    sqlserver.active_transactions

    Count

    The number of active transactions.

    SQLServer_Transactions

    sqlserver.transactions

    Count

    The average number of transactions per second.

    sqlserver.write_transactions

    Count

    The average number of write transactions per second.

    SQLServer_NetworkTraffic

    sqlserver.write_kb

    Per Second

    The inbound traffic per second of the RDS instance.

    sqlserver.read_kb

    Per Second

    The outbound traffic per second of the RDS instance.

    Note

    To provide bandwidth usage in a more accurate manner, ApsaraDB RDS allows your RDS instance to collect traffic statistics from the network interface controllers of Windows operating systems.

    Basic Monitoring

    Section

    Metric

    Unit

    Description

    SQLServer_BufferHit

    sqlserver.cache_hit_ratio

    %

    The hit ratio of the high-speed cache.

    sqlserver.bufferpool

    %

    The percentage of pages that are found in the high-speed cache to all pages that are read from disks.

    Full Table Scans

    sqlserver.fullscans

    Per Second

    The average number of full table scans per second.

    SQL Compiles per Second

    sqlserver.autoparam_attempts_per_sec

    Per Second

    The number of auto parameterization attempts per second.

    sqlserver.forced_parameterizations_per_sec

    Per Second

    The number of successful forced parameterizations per second.

    sqlserver.sql_compilations

    Per Second

    The number of SQL compilations per second.

    sqlserver.unsafe_autoparams_per_sec

    Per Second

    The number of unsafe auto parameterization attempts per second.

    sqlserver.failed_autoparams_per_sec

    Per Second

    The number of auto parameterization failures per second.

    sqlserver.safe_autoparams_per_sec

    Per Second

    The number of safe auto parameterization attempts per second.

    sqlserver.resqlcompilations

    Per Second

    The number of SQL statement recompilations per second.

    Pages Written by Checkpoint per Second

    sqlserver.lazy_writes

    Per Second

    The number of times that dirty pages are written to disks per second.

    sqlserver.checkpoint

    Per Second

    The number of dirty pages that the checkpoint operation must write per second.

    Logons per Second

    sqlserver.logout

    Per Second

    The number of logouts per second.

    sqlserver.logins

    Per Second

    The number of logons per second.

    Lock Timeouts per Second

    sqlserver.locktimeout

    Per Second

    The number of lock requests that time out per second, including requests for NOWAIT locks.

    Deadlocks per Second

    sqlserver.deadlock

    Per Second

    The number of lock requests that resulted in a deadlock per second.

    Lock Waits per Second

    sqlserver.lock_requests_per_sec

    Per Second

    The number of new locks and lock conversions per second.

    sqlserver.lockwaits

    Per Second

    The number of lock requests that the client waits for per second.

    sqlserver.latchwaits

    Per Second

    The number of latch requests that are not immediately granted per second.

    sqlserver.lock_waits

    Per Second

    The statistics of processes waiting for locks.

    sqlserver.lock_wait_time_ms

    Milliseconds

    The average amount of wait time for each lock request that resulted in a wait.

    sqlserver.average_latch_wait_time

    Per Second

    The average waiting time to request a latch resource.

    sqlserver.table_lock_escalations_per_sec

    Per Second

    The number of times that a lock on a table is escalated to the HoBT level or the table level.

    sqlserver.average_lock_wait_time

    Per Second

    The average waiting time of the requested lock resource.

    sqlserver.total_latch_wait_time_ms

    Per Second

    The total wait time for locks in the last second.