Tuesday, March 27, 2012

Does SQL Server 2005 Clean Up Unclosed Connections?

Hi all,
I have a quick question with regards to how SQL Server (2005) will treat
conncetions that are left open (due to a programmer forgetting to close
them in a .net web app).
I'm basically wondering if they'll just sit their indefinately, or will
SQL Server kill them after a period of inactivity? If it will eventually
kill them off, what is the period of time that it will wait for?
Thanks to anyone who can advise
SimonSQL Server will kill (first rollback if necessary) the connections when the
network layer had
informed that this is no more.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Simon Harvey" <nothanks@.hotmail.com> wrote in message
news:%23k1h3RqHHHA.420@.TK2MSFTNGP02.phx.gbl...
> Hi all,
> I have a quick question with regards to how SQL Server (2005) will treat c
onncetions that are left
> open (due to a programmer forgetting to close them in a .net web app).
> I'm basically wondering if they'll just sit their indefinately, or will SQ
L Server kill them after
> a period of inactivity? If it will eventually kill them off, what is the p
eriod of time that it
> will wait for?
> Thanks to anyone who can advise
> Simon|||Hi there
OK - now what will cause the network layer that the connection is no
more? The application or website being restarted?
Thanks
Simon
Tibor Karaszi wrote:
> SQL Server will kill (first rollback if necessary) the connections when th
e network layer had
> informed that this is no more.
>|||I guess that is more a question to the networking people. But if you termina
te the application, I'd
assume that the network layer will report that the TCP session (for instance
) has been terminated.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Simon Harvey" <nothanks@.hotmail.com> wrote in message news:Or9TxGtHHHA.1784@.TK2MSFTNGP06.ph
x.gbl...[vbcol=seagreen]
> Hi there
> OK - now what will cause the network layer that the connection is no more?
The application or
> website being restarted?
> Thanks
> Simon
> Tibor Karaszi wrote:

No comments:

Post a Comment