Hi,

Use ping to check the MTU between the sites, see this link for howto: http://support.microsoft.com/default.aspx?scid=kb;en-us;q314825

You may have a black hole router between source and destination.

Then Sync the SQL packet size less the overhead.

>My application is retrieving data from SQL Server 2000 over a WAN using ODBC (VFP 9). Users are complaining about the performance and the networking people at the customer are pointing to my application, saying that it is communicating with very small packets - like 250 bytes or so. Thus it takes over 10 separate packets to return one row of data (2568 bytes).
>
>I thought the default was something like 4KB packets?
>
>I'm not knowingly doing anything to set the packet size - is there something I can do (or should do) to improve this?
>
>Or is there some other quirk in what I have done that causes this?
>
>Thanks,
>Pat