ApsaraDB RDS:View standard monitoring information

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.