Amazon RDS for SQL Server
Welcome
- Welcome
Connect
- Connection Details
- Grant Account Permissions
Alarms (A-K)
- Alarms
- CPU Time Percentage Used
- Databases - Data File Group About to Grow
- Databases - Data File Group Space Used
- Databases - Dynamic Data File Group Growths Remaining
- Databases - Dynamic Log File Growths Remaining
- Databases - Log File Space Used
- Databases - Log Flush Wait Time
- Databases - SQL I/O Errors
- Databases - Unavailable
- Error Log - Error Count
- Error Log - Fatal Current Process Error (severity level 20)
- Error Log - Fatal Database Integrity Suspect Error (severity level 23)
- Error Log - Fatal Database (dbid) Processes Error (severity level 21)
- Error Log - Fatal Hardware Error (severity level 24)
- Error Log - Fatal Hardware Error (severity level 25)
- Error Log - Fatal Table Integrity Suspect Error (severity level 22)
- Error Log - High Severity Message
- Error Log - Information Severity Message
- Error Log - Low Severity Message
- Error Log - Medium Severity Message
- I/O Stall Time
- Index Fragmentation
- Index Fragmentation Status
Alarms (L-M)
- Latch - Total Wait Time Rate
- Locks - Blocked Processes
- Locks - Deadlocks
- Memory - Page Life Expectancy
- Missing SQL Performance Counters
- Monitored Server - Azure SQL Managed Instance Alarm Action Failure
- Monitored Server - Azure SQL Managed Instance Alarm Evaluation Failure
- Monitored Server - Azure SQL Managed Instance Collection Execution Failure
- Monitored Server - Azure SQL Managed Instance Connection Failure
- Monitored Server - Azure SQL Managed Instance Host Not Defined
- Monitored Server - Azure SQL Managed Instance Planned Outage
- Monitored Server - Azure SQL Managed Instance Secondary Connection Failure
Alarms (N-Z)
- Network - Azure SQL Managed Instance Packets Error Rate
- Performance Investigator
- Poor Performance Health
- SQL - Long Running SQL
- SQL - Running out of Threads
- SQL Agent - Jobs Failed
- SQL Agent - Long Running Jobs (Percent)
- SQL Agent - Long Running Jobs (Time)
- SQL Custom Counters
- SQL Virtual Log Files Count
- Tempdb Auto Growth
- Tempdb Contention
- Tempdb Version Store Generation Rate
- Tempdb Version Store Size
- User - Connection Count
- User - Logins Per Second
- User - Response Time
Spotlight Overview page
- Spotlight Overview page
- Sessions panel
- Flows
- Processes Panel
  - Total
  - System
  - User
  - Blocked Processes
  - CPU Usage
- Flows
  - Logical Reads
  - Compiles
- Memory panel
- Flows
- Disk Storage panel
- Performance Health panel
  - Performance Health
- System panel
  - Version
  - Host
  - Custom
  - Status
- Background Processes panel
  - Error Log
Memory drilldown
- Memory drilldown
- Memory Areas
- Server Memory
- Hit Rates
- Cache
- Buffer Cache Page Life Expectancy
SQL Activity drilldown
- SQL Activity drilldown
- Sessions page
- Summary page
- Locks page
  - Locks
  - Lock Types
  - Latches
- Blocking page
  - Blocking
  - Number of Blocked Processes
- Deadlocks page
  - Deadlock List
- I/O by File page
  - I/O by File grid
  - I/O by File chart
- Custom Counters page
  - Custom Counters chart
  - Custom Counters grid
- Query Execution Statistics page
Performance Health drilldown
- Performance Health drilldown
Wait Statistics drilldown
- Wait Statistics drilldown
- Wait Time Trend
- Waits Detail
Wait Events drilldown
- Wait Events drilldown
- SQL
- Plan
Databases drilldown
- Databases drilldown
- Databases page
  - Databases grid
- Summary page
  - Database Space
  - Database History
- File Groups page
- Data Files page
- Transaction Logs page
- Log Files page
- Tables page
- Indexes page
- Disk Space page
  - Disk Space chart
- Fragmented Indexes page
  - Fragmented Indexes grid
Support Services drilldown
- Support Services drilldown
- SQL Agent Jobs page
- Full Text Search page
  - Full Text Search Service
Configuration drilldown
- Configuration drilldown
- Configuration page
  - SQL Server Configuration grid
Error log drilldown
- Error log drilldown
- SQL Server Error Logs
- SQL Agent Error Logs
Workload Analysis drilldown
- Workload Analysis drilldown
- SQL
- Plan
Tempdb drilldown
- Tempdb drilldown
- Usage page
- Contention page
  - Wait Time
  - Sessions involved in this contention
Collections
- Collections
- Collect additional diagnostic information
Troubleshooting
- Troubleshooting

I/O by File chart

The I/O by File chart shows SQL Server I/O statistics for each Amazon RDS for SQL Server database file.

Tip: You can restrict the files(s) that are included in this chart by clicking on the file(s) you are interested in the grid at the top.

The following counters can be displayed by clicking the arrow next to the chart name:

Wait per I/O

The wait time per I/O (in milliseconds) for the selected database file.

Current I/O rate

The current rate at which Amazon RDS for SQL Server is performing physical read and write operations to this file (Reads rate plus Writes rate).

Current Read Rate

The current rate at which Amazon RDS for SQL Server is performing physical read operations from this file.

Current Write Rate

The current rate at which Amazon RDS for SQL Server is performing physical write operations to this file.

Total I/O

The number of kilobytes read from or written to this file since Amazon RDS for SQL Server started (KB Read plus KB Written).

Total Wait Time

The total number of milliseconds that Amazon RDS for SQL Server has spent waiting for I/O operations on this file since Amazon RDS for SQL Server started.

Current Wait Time

The number of milliseconds that Amazon RDS for SQL Server has spent waiting for I/O operations on this file since the last time data for this page was collected.