sleeping process (user logged off SSMS, but still there)

when user disconnects in SSMS, but SSMS is not totally closed, the user is still hanging in the one of the SPID as sleeping.

Is this default behavior?

if ssms window is totally closed then the process goes away.

thanks
LVL 6
anushahannaAsked:
Who is Participating?
 
Mohit VijayCommented:
yes its a default behaviour, SQL manage it internally.

These will go away after some time when it will run its internal process. the connection pool from a single web server usually keeps 10 processes open. This is for performance improvement.
0
 
anushahannaAuthor Commented:
that is interesting. if you find any msdn article on this specifically, please share.
0
 
Mohit VijayCommented:
0
 
anushahannaAuthor Commented:
Thanks again, very much.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.