Spotlight On SQL Server Features and Benefits

	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.

Podcast:
SQL Server Replication Monitoring
Find out how Spotlight on SQL Server Enterprise can help you monitor replication activities in your SQL Server environment.
Listen to the podcast now
Tech Brief:
Picking The Right Instrument for SQL Server Performance Monitoring
Learn more about how Spotlight on SQL Server Enterprise has helped Awareness Technologies over the native tools for monitoring and diagnosing performance issues in their environment. Written by Denny Cherry, of Awareness Technologies.
Read the tech brief
Feature Webcast:
Under the Hood of SQL Server 2008 Checking Out Internals
See a webcast on how Spotlight on SQL Server Enterprise overcomes the limitations of native tools for monitoring performance of your SQL Server environment.
Register for the Webcast

Features and Benefits