Spotlight On SQL Server Features and Benefits

	SQL Server, Analysis Services, Windows, VMWare and SQL Azure – Diagnose and optimize the SQL environments that are critical to your business.
	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.
	Complete High Availability Support – Comprehensive information on your SQL Server clusters, replication, database mirroring, and log shipping activities and environments.
	Diagnostic Drill Downs - Fully automated CPU and I/O 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 are uniquely critical to the business.
	Historical Playback– Navigate through up to two weeks of 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.

	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 (comes with Spotlight on SQL Server Xpert).		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.
	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.		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