Session Trace Trace was started and you cannot stop/kill it, but continues to reconnect. Spotlight has been showing the db as unhealthy since then.
The Spotlight Trace session is executing
create procedure sys.sp_trace_getdata
(@traceid int,
@records int = 0
)
as
select * from OpenRowset(TABLE TRCDATA, @traceid, @records)
Immediately after disabling 'extended events', the Performance Health went to 100%, but a Spotlight Session trace was still running and in addition, a Spotlight Deadlock Trace was started.
That trace is started is response to the user visiting the Session Trace tab in the Sessions drilldown. It supplies the data for the drilldown. Once user leaves that tab the trace should stop shortly afterwards.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center