Spotlight on SQL Server Enterprise 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.
What’s new in this version
New features in Spotlight on SQL Server 11.6:
l Federation - A Spotlight Client can now monitor connections from many Spotlight Diagnostic Server in a
federation. Spotlight Clients in the federation share the same custom views, templates, alarm actions
and list of planned outages. Refer to the new Spotlight on SQL Server Enterprise Federation Guide.
l Preview changes - When applying the configuration of a template or connection to one or more
connections, you can now preview all settings that are different to the Factory Settings in addition to
just the settings where the customized settings have changed.
l Spotlight Diagnostic Server - A new Spotlight Diagnostic Server home page shows status information for
the Spotlight Diagnostic Server connected to the Spotlight Client.
l Log of User Actions - Spotlight now maintains an audit log of user actions. The log is a historical record
of who changed what configuration when.
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
See also in the release notes:
- Resolved issues