This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Is Spotlight using SQL Extended Events as part of the monitoring?

We have Spotlight but I'm also finding 3 Extended Events (SpotlightDeadlockDetection_<server>_3843, SpotlightResponseTimeWaitData_<server>_3843 and SpotlightWorkloadAnalysis_<server>_3843).

Can these 3 events be stopped?

Parents
  • Hi,

    Yes, Spotlight uses Extended Events sessions for three collections:

    - Wait Events
    - Workload Analysis
    - Locks-Deadlocks

    You can find more information from our online document:
    help.spotlightessentials.com/enterprise_cfgds_extendedevents

    You can disable the usage of Extended Events session in Spotlight in two ways:

    1) Globally (for all connections):
    From the Configure toolbar, click Diagnostic Server icon and then select ‘Use of Extended Events’ option. Disable the ‘Use Extended Events’ flag

    2) At connection level:
    Keep the global flag enabled, and from the connection tree locate on the right-side pane of Spotlight, right-click on a SQL Server connection name to choose Properties option. From Details tab, disable the ‘Use Extended Events’ flag.

    Without Extended Events sessions, Wait Events and Workload Analysis drilldown won’t show any data. Deadlocks will be collected by SQL trace.

    Hope that has helped!

    Gita
    Spotlight Support Team
Reply
  • Hi,

    Yes, Spotlight uses Extended Events sessions for three collections:

    - Wait Events
    - Workload Analysis
    - Locks-Deadlocks

    You can find more information from our online document:
    help.spotlightessentials.com/enterprise_cfgds_extendedevents

    You can disable the usage of Extended Events session in Spotlight in two ways:

    1) Globally (for all connections):
    From the Configure toolbar, click Diagnostic Server icon and then select ‘Use of Extended Events’ option. Disable the ‘Use Extended Events’ flag

    2) At connection level:
    Keep the global flag enabled, and from the connection tree locate on the right-side pane of Spotlight, right-click on a SQL Server connection name to choose Properties option. From Details tab, disable the ‘Use Extended Events’ flag.

    Without Extended Events sessions, Wait Events and Workload Analysis drilldown won’t show any data. Deadlocks will be collected by SQL trace.

    Hope that has helped!

    Gita
    Spotlight Support Team
Children
No Data