You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The show_sleeping_spids flag is intended to show connections that are not performing any sql activity or holding any resources.
'Dormant' is the same as "sleeping", except a "DORMANT" SPID was reset after completing an RPC event from remote system (possibly a linked server). This cleans up resources and is normal; the SPID is available to execute.
CASE @show_sleeping_spids
WHEN 0 THEN
'AND not sp0.status in (''sleeping'',''dormant'')
'
WHEN 1 THEN
'AND
(
not sp0.status in (''sleeping'',''dormant'')
OR sp0.open_tran_count > 0
)
'
ELSE
''
END +
The text was updated successfully, but these errors were encountered:
The show_sleeping_spids flag is intended to show connections that are not performing any sql activity or holding any resources.
'Dormant' is the same as "sleeping", except a "DORMANT" SPID was reset after completing an RPC event from remote system (possibly a linked server). This cleans up resources and is normal; the SPID is available to execute.
The text was updated successfully, but these errors were encountered: