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 |
|
venkath
Posting Yak Master
202 Posts |
 Posted - 2008-07-01 : 11:33:00
|
| Hi allCan we configure a db to terminate idle sessions automatically?Thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-01 : 11:40:26
|
| Why you want to terminate those?Apps might be using/reusing for connection pooling. |
 |
|
|
venkath
Posting Yak Master
202 Posts |
Posted - 2008-07-01 : 11:47:12
|
| Yes Sodeep. I agree with you.But I would like to know if there is a way at DB level to automatically terminate the sessions which are idle for a long time?Thanks |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-01 : 11:54:32
|
| In tools-options-Query Execution -Advanced-disconnect after query executes . But don't recommend doing this. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-04 : 20:50:02
|
| This option doesn't work on remote app connections, should do that on client side. |
|
|
|
|
|
|
terminating idle sessions