• Relational Database Service

rds
  1. Help Center
  2. Relational Database Service
  3. User Guide
  4. Working with RDS for Microsoft SQL Server
  5. Viewing Monitoring Metrics

Viewing Monitoring Metrics

  • For details on ECS monitoring metrics, see Table 1.
  • For details on database monitoring metrics, see Table 1.
Table 1 Database performance monitoring metrics list

Metric

Description

Value Range

Database Connections in Use

Measures the number of database connections in use.

≥ 0 counts

Number of Transactions per Second

Measures the number of transactions started for the database per second.

≥ 0 counts/s

Number of Batches per Second

Measures the number of Transact-SQL command batches received per second.

≥ 0 counts/s

Number of Logins per Second

Measures the total number of logins started per second.

≥ 0 counts/s

Number of Logouts per Second

Measures the total number of logouts started per second.

≥ 0 counts/s

Cache Hit Ratio

Measures the percentage of pages found in the buffer cache without having to read from disks.

0% to 100%

Number of SQL Compilations per Second

Measures the number of SQL compilations per second.

≥ 0 counts/s

Number of SQL Re-Compilations per Second

Measures the number of statement recompilations per second.

≥ 0 counts/s

Number of Full Scans per Second

Measures the number of unrestricted full scans per second.

≥ 0 counts/s

Number of Errors per Second

Measures the number of errors per second.

≥ 0 counts/s

Number of Latch Waits per Second

Measures the number of latch requests that could not be granted immediately.

≥ 0 counts/s

Number of Lock Waits per Second

Measures the number of lock requests per second that required the caller to wait.

≥ 0 counts/s

Number of Lock Requests per Second

Measures the number of new locks and lock conversions per second requested from the lock manager.

≥ 0 counts/s

Lock Timeouts per Second

Measures the number of lock requests per second that timed out.

≥ 0 counts/s

Average Lock Wait Time

Measures the average amount of wait time (ms) for each lock request that resulted in a wait.

≥ 0 ms

Number of Deadlocks per Second

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

≥ 0 counts/s

Number of Checkpoint Pages per Second

Measures the number of pages flushed to disks per second by a checkpoint or other operations that require all dirty pages to be flushed.

≥ 0 counts/s

Number of Slow Queries

Measures the number of currently running slow queries.

≥ 0 counts