Spotlight now uses SQL Server Extended Events to gather data for these three features:
- Wait Events
- Workload Analysis
This issue we feel is related to a Microsoft SQL Server issue as described by Microsoft kb2511963. Please review both of the following Microsoft Links.
Spotlight not doing anything out of the ordinary. Queries for Extended events can be reviewed for example here:
- C:\Program Files\Dell\Diagnostic Server\Agent\conf\Package\sqlserver_spotlight\2008\WorkloadAnalysis.sql
- C:\Program Files\Dell\Diagnostic Server\Agent\conf\Package\sqlserver_spotlight\2008\WaitEvents
- C:\Program Files\Dell\Diagnostic Server\Agent\conf\Package\sqlserver_spotlight\2008\Deadlocks
We haven't had reports of this in SQL Server 2012 and up. So presumably, Microsoft addressed the issue there.