Re: Slow SQL serverperformance over 56k frame relay

Article View: comp.databases.ms-sqlserver

Article #158

Back to comp.databases.ms-sqlserver Previous Next

#158

From: Avnet CMG
Date: Tue, 04 Mar 1997 00:00

37 lines
2088 bytes

Hate to write this but 56K won't cut running NT.  We have the same and
simply connecting to the remote server is timely.  We run 56K about 5 miles
and it too slow, but when we run our T1 across the country, it is like
having the SQL Server next door.

I am convinced that your pipe is too narrow.
-- 
Michael Blaskey
Technology Solutions Mgr - Avnet
Private email 71003.1463@compuserve.com

Sanjay <sgupta@aegonusa.com> wrote in article
<01bc282a$ff59bd60$168f7ba2@sgupta>...
> We are getting slow MS SQL server performance while updating. The network
> configuration as follows:
> 
> The client PC is NT 4.0, connected to the SQL Server via 56 k frame relay
> link using TCP/IP protocol. The protocol is routed from the client lan to
> the SQL server location by IBM 2217 routers.
> 
> 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.
> 
> Any ideas will be greatly appreciated.
> 
> Sanjay Gupta
> sgupta@aegonusa.com
> 
>

Technical Details

Message-ID: <01bc28f0$c48cdfc0$0381090a@p104603>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <01bc282a$ff59bd60$168f7ba2@sgupta>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10e6f0,e8fc8ae4a6ff9a78
X-Google-Attributes: gid10e6f0,public
X-Google-Thread: 10396d,e8fc8ae4a6ff9a78
X-Google-Attributes: gid10396d,public
X-Google-Thread: fc256,e8fc8ae4a6ff9a78
X-Google-Attributes: gidfc256,public
X-Google-Thread: 104de1,e8fc8ae4a6ff9a78
X-Google-Attributes: gid104de1,public
From: "Avnet CMG" <michael.blaskey@avnet.com>
Subject: Re: Slow SQL serverperformance over 56k frame relay
Date: 1997/03/04
Message-ID: <01bc28f0$c48cdfc0$0381090a@p104603>
X-Deja-AN: 223108472
References: <01bc282a$ff59bd60$168f7ba2@sgupta>
Organization: Avnet, Inc.
Newsgroups: comp.databases.ms-sqlserver,cz.net.tcpip,microsoft.public.windowsnt.protocol.tcpip,relcom.tcpip

Reply to Parent Message