Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Release Notes

Configure the use of Extended Events

The Spotlight Diagnostic Server (by default) uses Extended Events to collect data from monitored SQL Server instances (SQL Server 2008 and above). The data is used by:

Open this screen from the Spotlight Client

  1. Click Configure | Diagnostic server.

  2. Select Configure the use of Extended Events.

Select the Diagnostic Server

For federated Spotlight Diagnostic Server (Federate Diagnostic Servers) you will be prompted to select the Spotlight Diagnostic Server to configure. Each Spotlight Diagnostic Server is independently configured in its use of Extended Events.

Select - Configure the use of Extended Events.

Select as appropriate.

Deselect

If you deselect the use of Extended Events then the Spotlight Diagnostic Server will stop collecting data for the SQL Server | Workload Analysis Drilldown and SQL Server | Wait Events Drilldown. This will not show up immediately on the user interface as the drilldowns will continue to show historical data till no data is available.

If you deselect the use of Extended Events then the Spotlight Diagnostic Server will use SQL Server Trace to collect data for deadlock checks.

Select

This is the default setting. If you select to use Extended Events (following a period of time when the use of Extended Events was deselected) the SQL Server | Workload Analysis Drilldown and SQL Server | Wait Events Drilldown may take a few minutes to repopulate with data.

 

Note: This setting affects all SQL Server monitored through the Spotlight Diagnostic Server. To set per monitored SQL Server see SQL Server | Connection Details.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating