Data is collected from the SQL Azure connection from the following 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.
Spotlight Overview page
Sessions panel
| Component |
Collection Name |
| Response Time |
SQL Azure - Response Time |
| Connections |
SQL Azure - Connections |
| Computers |
SQL Azure - Computers |
| Active |
SQL Azure - Sessions |
| Data Flows: Sessions to SQL Processes |
SQL Azure - Connections |
SQL Processes panel
| Component |
Collection Name |
| SQL Processes panel components |
SQL Azure - Sessions |
| Data Flows: SQL Processes to Data Storage |
SQL Azure - Sessions |
Data Storage panel
| Component |
Collection Name |
| Data Storage panel components |
SQL Azure - Database Space |
Version panel
| Component |
Collection Name |
| Version |
SQL Azure - Version |
SQL Activity drilldown
| Page |
Collection Name |
Notes |
| Sessions page |
SQL Azure - Session List |
|
| Session Locks |
SQL Azure - Locks List |
Non configurable |
Databases drilldown
| Page |
Collection Name |
| Summary page |
SQL Azure - Database Space |
| Tables page |
SQL Azure - Database Tables |
| Indexes page |
SQL Azure - Database Indexes |