Features and Benefits

Version 2.0

• Spotlight Statistics Repository - Stores long-term historical data for future analysis and planning purposes. You can use or build on the example reports provided or create you own reports by querying the data yourself.

• SQL Analysis - The SQL Analysis page has been added to the SQL Activity drilldown. SQL Analysis immediately highlights SQL being executed that does not conform to a set of user-defined performance criteria. You can view SQL from both a real-time and historical perspective. From the SQL Analysis page, you can use Quest SQL Tuning to tune the non-conforming SQL that you have identified.

• Historical Diagnostic Evaluation - Detailed information is available in Playback mode for the following alarms:
  • CPU alarm - Detailed information includes the top five CPU consumers at the time of the alarm
  • Disk Queue Length alarm - Detailed information includes the top five I/O bandwidth consumers at the time of the alarm
  • Blocking alarm - Detailed information includes the full blocking tree and the SQL of all participants

• Improved Enterprise Management of Diagnostic Server Configuration  - Diagnostic Server configuration is centralized and applied to all connections. Individual connections can then be customized as required

• Alarm notification - Run a program in response to an alarm and send email notifications to multiple recipients

• Windows-only connections in Spotlight Enterprise views - You can now add Windows-only connections to Spotlight Enterprise views.

• View and trace all sessions on one page

• Ability to import SQL Servers from a file as an alternative to scanning the network

• See everything important in one place– Spotlight shows you actual database and operating system activity in real time

• Increase management efficiency with views of database spaceand the internal structure of SQL Server log files

• Find problem SQL with SQL Analysis and tune them with the SQL Optimizer

• Diagnose past performance problems