Return
-
Title
Spotlight 13.3 introduces enhancements to the historical query execution plan and query execution plan analysis features. -
Description
Spotlight 13.3 introduces enhancements to the historical query execution plan and query execution plan analysis features. -
Resolution
Enhancements include:
- The query executions plans are consistently appearing in Playback mode in the SQL Activity, Query Execution Statistics, Workload Analyzer, and Wait Events dashboards.
- The query execution plan analysis provides additional five new rules:
- Missing Index
- Column with No Statistics
- Inefficient Scan:
- Table
- Cluster Index
- Index
- Inefficient Key/Rid Lookup
See the Execution Plan Diagnostics blog for additional details. - The query executions plans are consistently appearing in Playback mode in the SQL Activity, Query Execution Statistics, Workload Analyzer, and Wait Events dashboards.