Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

'Dormant' should be treated the same as 'sleeping' #110

Open
JC-aus opened this issue Nov 15, 2023 · 1 comment
Open

'Dormant' should be treated the same as 'sleeping' #110

JC-aus opened this issue Nov 15, 2023 · 1 comment

Comments

@JC-aus
Copy link

JC-aus commented Nov 15, 2023

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 +
@dbaid
Copy link

dbaid commented Dec 6, 2024

I agree with you

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants