🚀 go-pugleaf

Sanjay wrote:
> 

> The problem we are having is that response time for SQL Server records is
> about three times slower than what it is in LAN. However we have similar
> WAN links other places but they are using CISCO routers and performance is
> not affected over the WAN link. We lloked through the SMS trace for TCP/IP
> packets and there are TCPpackets during which we see upto 1 second elapsed
> time even the packet size is really small.

Are you using IP Sockets, or Named Pipes over Netbios over IP?  The
Netbios over IP scenario can be really messy over WAN links, as the
routers must do all sorts of nasty broadcast-spoofing.  Cisco's happen
to be very good at this stuff...Try using IP sockets, if not are you
using WINS/NBNS on the NT Servers?  We have an SQL server that we access
through a 56K link, and properly architected it can run very smoothly,
like there is no WAN at all.  

Another thing to look for is ODBC.  It tends to turn a simple 100 byte
query into pages of crap, are you using ODBC?

Dan.