SQL Server Performance Forum – Threads Archive
Connection wasn’t closed?Server->>Management->>CurentActivity->><img src=’/community/emoticons/emotion-4.gif’ alt=’;p’ />rocess->><img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />roperty <br /><br />if i open Process property and it’s empty for a while<br /> what does it mean?<br />Bad code?<br />Connection wasn’t closed?<br />I keep refreshing current connection and it still exist
If it is existing for a longer time, then it could be an orphan connection. But, It’s not uncommon to have a connection with a short period of empty process, because it might have just finished executing something and about to close the connection.
Its always better to confirm using QA by running SP_WHO or SP_WHO2, sometimes (mostly) GUI based tools will give false information. HTH _________
The equialent command for this action using QA is,DBCC INPUTBUFFER(SPID)and I’ve observed that even this command returns an empty results for this kind of situation.
Also consider referring Kalen Delaney’s article in SQLMAG InstantDoc #38674, worth understanding the process. _________