Slow connection over the network

SP4 on a 2k3 box with sp1.  Client program is on an XP box on the same switc
h
as the server.  We've tried TCP/IP and named pipes, but no matter what, when
our program executes on the server it's fast and when it executes on the
client it's slow.  The network says it's running at 100mb/s.  Any hints on
where to look for possible causes?  TIA.

Dear William,

You should troubleshoot this issue step by step.
obviously you can open SQL Profiler, and monitor the Duration of the
requests on sql server.

But i have one hint: do you have any querry inside your program executing
inside a loop!
Also, is you application consisting of 1 client and 1 server?
and another hint, you can monitor the client pc, maybe other processes are
taking the resources of the system.
Good Luck

"William Sullivan" wrote:

> SP4 on a 2k3 box with sp1.  Client program is on an XP box on the same swi
tch
> as the server.  We've tried TCP/IP and named pipes, but no matter what, wh
en
> our program executes on the server it's fast and when it executes on the
> client it's slow.  The network says it's running at 100mb/s.  Any hints on
> where to look for possible causes?  TIA.