ApsaraDB RDS:View standard monitoring

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 page, select a time range on the Standard View tab to view the corresponding monitoring data. The following table describes the metrics.

   SQL Server service process

   Metric	Metric description	Unit	Description
   SQL Server CPU Utilization	sqlserver.cpu_usage	%	The CPU utilization of the RDS instance within the operating system.
   IOPS	sqlserver.db_io	Count	The number of I/O requests per second.
   	sqlserver.db_io_read	Count	The number of read I/O requests per second.
   	sqlserver.db_io_write	Count	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 clear error logs of the instance in the console or by calling an API operation.
   	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

   Metric	Metric description	Unit	Description
   QPS	sqlserver.qps	Count	The average number of SQL statements executed per second.
   Connection	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.
   SQL Server Transactions	sqlserver.transactions	Count	The average number of transactions per second.
   	sqlserver.write_transactions	Count	The average number of write transactions per second.
   SQL Server Network Traffic	sqlserver.write_kb	KB	The inbound traffic per second of the instance.
   	sqlserver.read_kb	KB	The outbound traffic per second of the instance.
   SQL Server AlwaysOn Primary-Secondary Latency	sqlserver.alwayson_lagsecs	Seconds (s)	The primary-secondary latency of an SQL Server Cluster Edition instance.

   Note

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

   Basic monitoring

   Metric	Metric description	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	Count	The average number of full table scans per second.
   SQL Compilations per Second	sqlserver.autoparam_attempts_per_sec	Count	The number of auto parameterization attempts per second.
   	sqlserver.forced_parameterizations_per_sec	Count	The number of successful forced parameterizations per second.
   	sqlserver.sql_compilations	Count	The number of SQL compilations per second.
   	sqlserver.unsafe_autoparams_per_sec	Count	The number of unsafe auto parameterization attempts per second.
   	sqlserver.failed_autoparams_per_sec	Count	The number of auto parameterization failures per second.
   	sqlserver.safe_autoparams_per_sec	Count	The number of safe auto parameterization attempts per second.
   	sqlserver.resqlcompilations	Count	The number of SQL statement recompilations per second.
   Page Write Frequency at Check Point	sqlserver.lazy_writes	Count	The number of times that dirty pages are written to disks per second.
   	sqlserver.checkpoint	Count	The number of dirty pages that the checkpoint operation must write per second.
   Logons per Second	sqlserver.logout	Count	The number of logouts per second.
   	sqlserver.logins	Count	The number of logons per second.
   Lock Timeouts per Second	sqlserver.locktimeout	Count	The number of lock requests that time out per second, including requests for NOWAIT locks.
   Deadlocks per Second	sqlserver.deadlock	Count	The number of lock requests that resulted in a deadlock per second.
   Lock Waits per Second	sqlserver.lock_requests_per_sec	Count	The number of new locks and lock conversions per second.
   	sqlserver.lockwaits	Count	The number of lock requests that the client waits for per second.
   	sqlserver.latchwaits	Count	The number of latch requests that are not immediately granted per second.
   	sqlserver.lock_waits	Count	The statistics of processes waiting for locks.
   	sqlserver.lock_wait_time_ms	Milliseconds (ms)	The average amount of wait time for each lock request that resulted in a wait.
   	sqlserver.average_latch_wait_time	Milliseconds (ms)	The average waiting time to request a latch resource.
   	sqlserver.table_lock_escalations_per_sec	Count	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	Milliseconds (ms)	The average waiting time of the requested lock resource.
   	sqlserver.total_latch_wait_time_ms	Count	The total wait time for locks in the last second.