Note: This feature is available only in Spotlight on SQL Server Enterprise.
Reporting schedules determine when and how often data is collected for the Spotlight Statistics Repository. Use the following tables to determine which schedules to adjust to collect more or less information for a particular Reporting and Trending View or Report and whether the collections are written to history.
Documentation is provided for how to configure these collections. See "Configure Scheduling" (page 1) for more information.
Data collection for Views > SQL Server Configuration
| View Name | Collection Name | Collection Type |
|---|---|---|
| Instance Configuration - Server Property Values Grid | Server Properties | SQL Server |
Data collection for Views > SQL Server Health
| View Name | Collection Name | Collection Type |
|---|---|---|
| Index Summary | SQL Index Summary | SQL Server |
| Plan Cache (2005) | Bottom 250 dm_exec_query_stats Entries | SQL Server |
| Bottom 250 sysCacheObjects Entries | SQL Server | |
| Top 250 dm_exec_query_stats Entries | SQL Server | |
| Top 250 sysCacheObjects Entries | SQL Server | |
| Redundant and Reverse Indexes | Redundant Indexes | SQL Server |
| Reverse Indexes | SQL Server | |
| Table Summary | SQL Table Summary | SQL Server |
| Tables Missing Clustered Indexes or Primary Keys | Tables Missing Clustered Indexes | SQL Server |
| Tables Missing Primary Keys | SQL Server |
Data collection for Reports
| Report Name | Collection Name | Collection Type |
|---|---|---|
| Database Growth Report | Database List | SQL Server |
| Deadlock List | Deadlock List | SQL Server |
| SQL Server Health Report | Buffer Manager | SQL Server |
| Cache Manager | SQL Server | |
| Memory Manager | SQL Server | |
| SQL Server Connections | SQL Server | |
| Statistics | SQL Server | |
| Windows Server Health Report | SQL CPU Percent | SQL Server |
| Logical Disks | Windows | |
| Memory | Windows | |
| Network | Windows | |
| Processors | Windows | |
| System Performance | Windows |
