freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: poor performance thru the firewall

From: James Cameron <cameron AT fax.sno.cpqcorp.net>
To: TDS Development Group <freetds AT franklin.oit.unc.edu>, chris AT creditguard.org
Subject: Re: poor performance thru the firewall
Date: Thu, 03 Jan 2002 08:53:22 +1100

Chris,

That '40 seconds' smells like a DNS lookup timeout.

Check that the database server can resolve the IP address it sees the
connection coming from. 'nslookup n.n.n.n' If the intervening firewall
uses NAT, then the IP address will match the firewall's interface
closest to the database server.

Gather more information on the connection to the database server, using
tcpdump or similar on the interface of the machine making the
connection. Examine the timings of packets to determine where the delay
is occurring.

--
James Cameron

poor performance thru the firewall, Chris Waidele, 01/02/2002
- <Possible follow-up(s)>
- Re: poor performance thru the firewall, James Cameron, 01/02/2002
- Re: poor performance thru the firewall, Chris Waidele, 01/03/2002