Wait Statistics does not depend on Extended Events. The query Spotlight runs is called QS_WaitStats.sql and it makes no calls to Extended Events. It can be reviewed from this Spotlight install directory: C:\Program Files\Quest Software (or Dell)\Diagnostic Server\Agent\conf\Package\sqlserver_spotlight.
These are the only three features dependent on Extended Events:
- Wait Event
- Workload Analysis
- Deadlocks
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center