Posted by Oscar Santiesteban Jr. on 01/19/06 02:18

Thanks Erland for the comments. Here is some follow up.
The "Audit Logoff" seems to come from the client. We have monitored all
connections using ETHERReal and the logoff comes from the IP address.

Vendor claims that our data center move caused this. Another thing is that
previously, the NIC of the server (10/100) was hooked up to a switch, which
then went to a CISCO 6509 switch. The server is now connected at 1000
(gigabit) directly to the server. Don't know if that changes anything.
Vendor claims that some hardware (switch/router/etc...) is flaky.

We have enen removed the most recent MS patch, installed by our SMS server,
and things are still the same. This server has over 300 connections daily
and at times of high use, it bogs down with excessive login/logoffs.

> It sounds as if connection pooling was turned off. Most applications
> these days - and it does not have to be .Net - works with the paradigm
> that they connect, run a query and then disconnect. Under the covers,
> the client API maintains a connection pool, which means that a logical
> disconnect is not directly a physical, but if there is a reconnection
> within 60 seconds, the connection will be reused.
>
> But this is stricly a client-side feature, so moving a server should not
> cause this, but there has to be some change on the client side for
> connection pooling to be ditched.
>
> An other alternative is that SQL Server would itself close the connection,
> but this only happens on error; SQL Server does not have any inactivity
> monitor.
>
> That leaves the network. The network could be configured to drop the
> connection when nothing have happned for n seconds. But in such case,
> I would expect the client to report errors, as most clients are not
> prepare for this form of brutal disconnection. Still I would investigate
> networks and firewalls.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]