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

User - Response Time alarm

The User - Response Time alarm is raised when the time taken for Spotlight to send a simple query to the monitored Amazon RDS for SQL Server instance, have it processed and get the answer back is more than 20 seconds (or the configured threshold). The Response Time alarm does not tell you where the time is spent; it could be the network or it could be the Amazon RDS for SQL Server instance is unresponsive.

This is not an error. Spotlight is just saying that it is taking over 20 seconds (or the configured threshold) to run the response time query in your environment. This could be indicative of:

Response time SQL blocking (Check the configured Response Time SQL)
A network issue between the Spotlight Diagnostic Server and the monitored Amazon RDS for SQL server(s)
A problem with the monitored Amazon RDS for SQL Server(s)

You may want to find out what the Response Time SQL is (default “select 1”) and run that SQL from SQL Server Management Studio from the Spotlight Diagnostic Server host against one of the monitored Amazon RDS for SQL Servers exhibiting the issue.

In the Spotlight Client, members of the Spotlight diagnostic administrators group can change the SQL Statement used to measure SQL Server response time.

Tags: