No of processes

Last Post 14 Sep 2010 06:06 AM by sql-tips. 3 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
sql-tips
New Member
New Member

--
13 Sep 2010 09:59 AM
There are always 5-6 thousand sessions hanging with status of sleeping. Is there any harm to database having so many sessions like these, or shall I suggest developer to revisit the code. I guess every time they use temp tables there are not closing the sessions. any input appreciated.
rm
New Member
New Member

--
13 Sep 2010 10:48 AM
Each session needs memory, should ensure apps can reuse connections in pool instead keep opening new connection.
gunneyk
New Member
New Member

--
13 Sep 2010 01:52 PM
Are these all different spids? If so it sounds like you should be using connection pooling. And yes rm is correct in that each connection uses memory but 6K connections is absurd. I have seen some of the busiest systems in the world with much less connections when done properly.
sql-tips
New Member
New Member

--
14 Sep 2010 06:06 AM
Thanks rm and gunneyk. there was a connections leakage in the code and fixed now.


Acceptable Use Policy
---