Spotlight on SQL Server Enterprise

Spotlight

Every business relies on its database infrastructure to maintain service levels and to provide the decision making support executives rely on to succeed. Spotlight on SQL Server Enterprise allows you to monitor, diagnose and optimize your SQL Server, Analysis Services, VMWare ESX and SQL Azure database environments to ensure peak performance around the clock. With intuitive overviews of enterprise health and performance, automated alerts and actions, and an integrated Xpert tuning module, DBAs can ensure optimal performance more simply than ever before.

Understand your SQL Server infrastructure health at a glance
Monitor SQL Server’s relational engine, Analysis Services, Windows, VMWare ESX and SQL Azure from a single console (read the datasheet)
Extend the robust built-in metrics and alarms with custom collections and alarms
Automate performance metric analysis
Resolve issues quickly, including long-running processes, blocking locks, deadlocking and more

Features and Benefits

Spotlight® on SQL Server Enterprise

	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.