Spotlight, the real-time diagnostics and resolution tool, enables administrators to anticipate and correct availability and performance issues prior to a negative impact on business processes - assuring the integrity of your business initiatives and service level agreements.

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.

Overview

• Understand SQL Server infrastructure health at a glance.

• Monitor SQL Server’s Analysis Services relational engine, as well as Windows and SQL Azure,from a single console.

• Extend the robust built-in metrics and alarms with custom collections and alarms.

• Automate the analysis of performance data.

• Resolve issues quickly, including long-running processes, blocking locks, deadlocking and more.