SQL Server Performance Forum – Threads Archive

Connection wasn’t closed?

Server-&gt;&gt;Management-&gt;&gt;CurentActivity-&gt;&gt<img src=’/community/emoticons/emotion-4.gif’ alt=’;p’ />rocess-&gt;&gt<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 _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

---

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. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

---

thank you

---

]]>