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 |
|
1247548
Starting Member
1 Post |
 Posted - 2011-03-30 : 03:50:27
|
| Hi;I am facing issue because of the idle DB connections, my one databse is showing approximatly 100 db connections and application is not controlling and closing open connections even if connection idle for long time. I want to controll this from SQL 2005 side.I want to change the setting to terminate all idle db connections.Tahnks |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2011-03-30 : 18:45:46
|
| While this can be done, I'll strongly recommend enforcing connection closing at the application level. Also, if connection pooling is being used, the connection will remain open even if the application "closes" it. This is normal and desired.=======================================Elitism is the slur directed at merit by mediocrity. -Sydney J. Harris, journalist (1917-1986) |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQL DB Connection termination