Data is collected from the SQL Azure connection from the following Spotlight collections.
How to configure Spotlight collections
Use a Spotlight Client to configure Spotlight collections. See Configure Scheduling
From the Spotlight Client
- Click Configure | Scheduling.
- Select template or connection to configure
- Select a collection to modify the collection schedule.
Alarms
| Alarm | Collection name | Notes |
|---|---|---|
| Compiles - Percentage Recompilations alarm | Statistics | |
| CPU Time Percentage Used alarm | SQL CPU Percent | |
| SQL Custom Counters alarm | Custom Counters - SQL Server | |
| Databases - Data File Group About to Grow alarm | File Groups | |
| Databases - Data File Group Space Used alarm | Files Groups | Minimum refresh for this collection is 60 seconds |
| Databases - Dynamic Data File Group Growths Remaining alarm | Files Groups | Minimum refresh for this collection is 60 seconds |
| Databases - Dynamic Log File Growths Remaining alarm | Files | Minimum refresh for this collection is 60 seconds |
| Databases - Log File Space Used alarm | Files | Minimum refresh for this collection is 60 seconds |
| Databases - Log Flush Wait Time alarm | Database Info | |
| Databases - SQL I/O Errors alarm | Global Variables | |
| I/O Stall Time alarm | Virtual File Statistics | |
| Index Fragmentation alarm | Fragmentation by Index | |
| Index Fragmentation Status alarm | Fragmentation by Index | |
| Latch - Total Wait Time Rate alarm | Latches Locks | |
| Locks - Blocked Processes alarm | Blocking List | |
| Locks - Deadlocks alarm | Deadlock List | |
| Memory - Page Life Expectancy alarm | Buffer Manager | |
| Missing SQL Performance Counters (displayed in Spotlight Today) alarm | Check Performance Counters | Non configurable |
| Network - SQL Server Packets Error Rate alarm | Global Variables | |
| SQL - Long Running SQL alarm | Long Running SQL Session Details |
Non configurable |
| SQL - Running Out Of Threads alarm | SQL Server Worker Threads | Non configurable |
| SQL Virtual Log Files Count alarm | SQL Virtual Log Files Count | |
| Tempdb Auto Growth alarm | Tempdb File Auto Growth | |
| Tempdb File Size alarm | Tempdb File Size | |
| Tempdb Version Store Generation Rate alarm | Tempdb Performance Counters | |
| Tempdb Version Store Size alarm | Tempdb Space Usage | |
| User - Connection Count alarm | SQL Server Connections | |
| User - Logins Per Second alarm | Global Variables | |
| User - Response Time alarm | Response Time |
Spotlight Overview page
| Panel, Component | Collection name | Notes |
|---|---|---|
| Sessions panel | SQL Server Connections | |
| Processes panel | SQL Server Connections | |
| Memory panel | Memory Manager | |
| Memory panel | Buffer Cache | Buffer Manager | |
| Memory panel | Procedure Cache | Cache Manager | |
| Data Storage panel | Data Files, Log Files | General DB Stats | |
| Data Storage panel | Tempdb | Nil. Component attached to alarms. | |
| Data Storage panel | Max I/O Wait | IO Stall | |
| Performance Health panel | Performance Health | |
| System panel | Version | Version Information | Non configurable |
Memory drilldown
| Page, grid, chart | Collection Name |
|---|---|
| Summary | Memory Areas chart | Memory Manager |
| Summary | Server Memory chart | Memory Manager |
SQL Activity drilldown
| Page, grid, chart | Collection Name | Notes |
|---|---|---|
| Sessions | Full Session List | |
| Sessions | SQL | Session Details | Non configurable |
| Sessions | Session Trace | Session Trace | Non configurable |
| Sessions | Session Locks | Locks List | |
| Summary | Access Methods charts | Access Methods | |
| Summary | CPU Utilization (SQL Server) | SQL CPU Percent | |
| Locks | Locks List | |
| Locks | Locks Types charts | Lock Statistics | |
| Locks | Latches chart | Latches Locks | |
| Blocking | Decode Wait Resource | Non configurable |
| Blocking | Blocking List | Non configurable |
| Deadlocks | Deadlock List | |
| I/O by File | Virtual File Statistics | |
| Custom Counters | Custom Counters - Amazon RDS for SQL Server | |
| Query Execution Statistics | QueryExecutionStatistics |
Wait Statistics drilldown
| Page, grid, chart | Collection Name |
|---|---|
| Wait Time Trend chart | Wait Statistics |
Performance Health drilldown
| Page, grid, chart | Collection Name |
|---|---|
| Rating | Performance Health |
| Instance Wait Time | WaitsByCategory |
| I/O Latency | Performance Health |
Wait Events drilldown
| Page, grid, chart | Collection Name |
|---|---|
| All | Waits Events |
Databases drilldown
| Page, grid, chart | Collection Name | Notes |
|---|---|---|
| Databases | Database List | |
| Databases | General DB Properties | |
| Databases | Summary | Database History charts | Database Info | |
| Databases | File Groups page | File Groups | |
| Databases | Data Files page | Files | Minimum refresh for this collection is 60 seconds |
| Databases | Transaction Logs page | File Groups | |
| Databases | Log Files page | Files | Minimum refresh for this collection is 60 seconds |
| Databases | Tables page | Tables | Non configurable |
| Databases | Indexes page | Indexes | Non configurable |
| Databases | Indexes | Fragmentation | Fragmentation List | Non configurable |
| Databases | Indexes | Statistics | Index Statistics | Non configurable |
Support Services drilldown
| Page, grid, chart | Collection Name | Notes |
|---|---|---|
| Full Text Search page | Full Text Catalog |
Configuration drilldown
| Page, grid, chart | Collection Name | Notes |
|---|---|---|
| Configuration List | Collection performed only once when entering the Configuration drilldown | |
| Version Information | Non configurable | |
| Submit update | Configuration Update | Non configurable |
Workload Analysis drilldown
| Page, grid, chart | Collection Name |
|---|---|
| All | Workload Analysis |
Tempdb drilldown
| Page, grid, chart | Collection Name |
|---|---|
| Configuration Health | Tempdb Configuration Checks; Tempdb File Auto Growth; Tempdb File Location |
| Usage | Tempdb Session Space Usage; Tempdb Space Usage; Tempdb Performance Counters |