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.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 使用条款 隐私 Cookie Preference Center