Workload Analysis and Wait Events no longer show data after connection has been disconnected and reestablished.
说明
Workload Analysis and Wait Events no longer show data after connection has been disconnected and reestablished. User as to disable Spotlight monitoring and then enable it again. The Extended Events will again work for a time but not for long.
解决办法
Issue fixed in the current release of Spotlight on SQL Server Enterprise. Latest version of Spotlight can be downloaded from here.