Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL session ID vs ASP.NET session ID

Author  Topic 

Sun Foster
Aged Yak Warrior

515 Posts

Posted - 2011-04-07 : 13:47:41
SQL administrator told me that my asp.net app do not close all connections.
He sent me a list as below and said this will cause memory leaking. Is it true?

session ID: about 150 ID
status: sleeping
command: awaiting command
application: Net SqlClient Data Provider

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-04-07 : 13:53:33
Are you using connection pooling?

I don't see why the SQL admin would be concerned about 150 idle connections. Big deal. 150 idle connections will use an extremely low amount of memory.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -