 | Custom Reporting – The Spotlight on SQL Server Enterprise Report pack is a package of 22 customizable reports for enterprise-level performance metrics which provide a clear understanding of almost any area of concern in your environment. This pack is available exclusively on our SQL Server community where all feedback can be given and new reports shared. |
| Wait-State Analysis – The Wait Statistics view available in the SQL Activity drill downs allow you to diagnose performance problems that are caused by waits. You can easily find out where waits are occurring and what is causing the event. |
| Trending – Access views and reports to assist with long-term trend analysis. By configuring the Diagnostic Server to store statistics in the Spotlight Statistics Repository, this data can be retrieved for trend reporting. |
 | Spotlight Statistics Repository – Stores long-term historical data for future analysis and planning purposes. You can use or build on the example reports provided or create your own reports by querying the data yourself. |
| SQL Analysis – The SQL Analysis page is part of the SQL Activity drilldown. SQL Analysis immediately highlights SQL being executed that does not conform to a set of user-defined performance criteria. You can view SQL from both a real-time and historical perspective. From the SQL Analysis page, you can use the integrated Quest SQL Optimizer for SQL Server to tune the non-conforming SQL that you have identified. |
| Historical Playback – Detailed information is availalble in Playback mode to view historical performance alarms. |
| Xpert Tuning – Completely automate the process of resolving SQL performance issues. Xpert tuning through the integrated Quest SQL Optimizer for SQL Server will identify, tune and benchmark problematic SQL in your SQL Server environment, regardless of where your SQL resides. Xpert tuning also provides the ability to investigate indexing strategies through automated index generation. |