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.
| Author |
Topic |
|
ts_abbott@hotmail.com
Starting Member
36 Posts |
 Posted - 2004-11-16 : 10:12:26
|
| i'm looking after several apps at the moment and i'd like to know if any of them aren't closing connections properly. if i run sp_who it lists all connections. fine. asp.net however pools connections so there are always a couple open. so is there anyway to determine through sql server if one of my apps is leaking a connection? |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-11-16 : 21:20:25
|
| you can check the sysprocesses entries and compare the login time and last batch or log the last batch in a table, then check after 15 minutes or so, if it hasn't changed then you can kill the spid.--------------------keeping it simple... |
 |
|
|
ts_abbott@hotmail.com
Starting Member
36 Posts |
Posted - 2004-11-17 : 09:27:39
|
| thanks jen, i'll give it a go. |
|
|
|
|
|
|
leaking connections