Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Release Notes

Release Notes

Spotlight® on SQL Server 11.7.1

Release Notes

December 2016

These release notes provide information about the Spotlight on SQL Server Enterprise release.


About this release

Spotlight on SQL Server is a powerful database diagnostic and resolution tool. Its unique user interface provides you with an intuitive, visual representation of the activity on a SQL server. Graphical flows illustrate the rate at which data is moving between server components. Icons display the value of key statistics and alarms. Alarms inform you of bottlenecks and other potential problems. Drilldowns show detailed information on all parts of your SQL Server.

Spotlight integrates data from various sources into a single display. It seamlessly combines data from SQL Server system tables, SQL commands, performance monitor counters, and the Windows registry. Spotlight diagnoses not just your SQL Server, but also the Windows Server that SQL Server is running on.

With Spotlight, diagnostic data can be collected continuously, even when Spotlight is not open on the desktop. A Diagnostic Server can perform data collection continuously from a middleware machine, ready for Spotlight to display whenever Spotlight is started on any client machine.

Business benefits include:

  • Data collected and alarms evaluated on a 24x7 basis, even when no Spotlight clients are running.
  • Identical data and alarms provided to all users, providing a consistent view across the enterprise.
  • Diagnostic data is saved in one place (on the Diagnostic Server), avoiding unnecessary replication of data.
  • Diagnostic Server reduces load on databases and operating systems by collecting data once and sharing it between all connected Spotlight clients.
  • Long-term historical data can be stored in a repository for future analysis and planning purposes. SQL Server professionals can report off the data for a deeper understanding of their performance issues.
  • Diagnostic Server configuration is centralized and applied to all connections. Individual connections can then be customized as required.
  • SQL Analysis captures SQL from a SQL Server based on a collection filter you specify and allows you to quickly get a picture of the most expensive SQL running on the server both from real-time and historical perspectives.
  • Operating System data is collected only once, even if multiple instances are being monitored on that particular host.
  • Spotlight on SQL Server Enterprise 11.7.1 is a patch release,

New Features

New features in Spotlight on SQL Server Enterprise 11.7:

  • Template Apply - You can now select individual alarm and schedule configurations to apply.
  • Federation - Use the Federate Diagnostic Servers dialog to determine the number of connections monitored by each Spotlight Diagnostic Server and the number of connections monitored by the federation.

Note that the Deadlocks, Wait Events and Workload Analysis features in Spotlight on SQL Server Enterprise make use of Extended Events. Spotlight will continue to use Extended Events in the development of the product's features.

See also:



The following is a list of enhancements implemented in Spotlight on SQL Server Enterprise11.7.1.

Table 1: General enhancements

Enhancement Issue ID
If configured to upload to the Spotlight Cloud then the collections now being uploaded allow for monitoring connection drilldowns on the web site once corresponding development of the web site is complete. 6077

Enhanced monitoring and diagnosis of connections with over 2000 active sessions.

Reporting and Trending: The RDL files have moved to the SSRS folder in the Spotlight Client installation folder. 6214

The following is a list of enhancements implemented in Spotlight on SQL Server Enterprise 11.7.

Table 2: General enhancements

Enhancement Issue ID
Spotlight now monitors Windows Server 2016 and Windows 10 in a Hyper-V virtualized environment. 5986

When the alarm severity is normal and that alarm is listed in the Alarm log and actioned as an email, the corresponding alarm message for normal severity is displayed.

The dialogs to configure an alarm and configure a schedule have been enhanced to make it clearer that a Factory Settings Template cannot be edited. 6007
Configure | Connections - The Connection Type is now selectable from a drop down menu; in place of the old button / scroll menu. 5830


Deprecated Features

The following is a list of features that are no longer supported.

  • Starting with Spotlight on SQL Server Enterprise11.7.1 the SQL Server Diagnostics CPU and IO drilldowns have been deprecated in favor of the SQL Server | Workload Analysis drilldown CPU Resource and the SQL Server Wait Events drilldown | IO Category.
  • Starting with Spotlight on SQL Server Enterprise 11.7, Reporting and Trending | Spotlight Views have been deprecated. They are now available as printable Spotlight Reports.

Spotlight is deprecating Enterprise Views post this release. We recommend taking advantage of the new Connection Views to monitor your SQL Server instances in groups.

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating