Features and BenefitsSpotlight® on SQL Server Enterprise | Analysis Services – Monitor and alarm on SQL Server Analysis Services from a single interface. | | Top SQL and Real-Time Query Plans – Pinpoint critical SQL statements running in your environment based on index utilization, resource consumption or, query efficiency and immediately review run-time query plans. | | CPU Diagnostic Drill Down – Fully automated CPU performance diagnosis and resolution. | | Custom Performance Counters – Track and alarm on service level-specific processes as though they were metric counters to proactively handle performance issues that uniquely critical to the business. | | Historical Playback– Navigate through performance diagnostics and alarm data to resolve recent performance issues from any Spotlight management screen. | | Custom Reporting and Trending – Understand the health, activity, and capacity trends of your SQL Server enterprise with a large variety of integrated management and performance views, client-side reports, and the Spotlight on SQL Server Enterprise Report pack. Check out Quest’s SQL Server community for updates to and discussions on this feature. | | Integrated Links to SQLServerPedia – Get up-to-the-minute, context-specific advice and background on the performance issues you’re diagnosing from the expert editors and blog content on SQLServerPedia. |
| SQL Analysis and Xpert Tuning – Highlight long-running queries and sub-optimal code and immediately tune, benchmark and investigate indexing strategies through integration with Quest SQL Optimizer for SQL Server. | | Wait-State Analysis - Diagnosing Wait Statistics allows DBAs to easily determine where waits are occurring and what is causing the event. | | Spotlight Statistics Repository – Configure long-term metric data storage for historical trending and capacity planning initiatives. | | Deadlock Detection and Review – Complete visibility of deadlock events and the conditions that caused them. | | Alarm Notification and Snooze – Craft custom responses to resource bottlenecks, job failures and other operational anomalies visually, via email or programmatically. | | Windows-only connections views – Add Windows-only connections to Spotlight on SQL Server Enterprise views. |
-
-
CommunityAdditional InformationNext Steps
|