On Feb 7, 12:59 pm, "
pcovie...@gmail.com" <
pcovie...@gmail.com> wrote:
> we are looking to see if there is one process that is causing our odbc timeouts. as far as network traffic. we are not seeing anything, the other morning it happened between 1 and 6 am. and eia0 showed virtually nothing hitting it... and there is no one working during those hours, just automated jobs. and it is sporadic... no set time or day!
The question then becomes:
Is there a connection that exists that is timing out and disconnecting
or is a connection attempting to be established that is failing. In
the first case, an inactivity timer may be closing the connection. In
the second, it still points to a network connectivity issue rather
than a performance problem. I would attempt to log the network
activity on the receiving side using a packet trace utility. With the
ODBC failure, you should know the time and machine address. Search
the traces for that info and see what is happening. Chasing the
performacne of the machine here, I believe, will just waste time.
Dan