These release notes provide information about the Spotlight on SQL Server Enterprise 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:
New features in Spotlight on SQL Server Enterprise 11.7:
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.
The following is a list of enhancements implemented in Spotlight on SQL Server Enterprise11.7.1.
Table 1: General enhancements
|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
|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|
The following is a list of features that are no longer supported.
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.