|
Home > Archive > MS SQL Server > July 2005 > Slow connection over the network
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Slow connection over the network
|
|
| William Sullivan 2005-07-27, 9:23 am |
| SP4 on a 2k3 box with sp1. Client program is on an XP box on the same switch
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.
| |
| Mario Aoun 2005-07-28, 3:23 am |
| 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 switch
> 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.
|
|
|
|
|