Slow SQL serverperformance over 56k frame relay

Article View: comp.databases.ms-sqlserver

Article #157

Back to comp.databases.ms-sqlserver Previous Next

#157

From: Sanjay
Date: Mon, 03 Mar 1997 00:00

19 lines
1530 bytes

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: <01bc282a$ff59bd60$168f7ba2@sgupta>

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10e6f0,e8fc8ae4a6ff9a78,start
X-Google-Attributes: gid10e6f0,public
X-Google-Thread: 10396d,e8fc8ae4a6ff9a78,start
X-Google-Attributes: gid10396d,public
X-Google-Thread: 104de1,e8fc8ae4a6ff9a78,start
X-Google-Attributes: gid104de1,public
X-Google-Thread: fc256,e8fc8ae4a6ff9a78,start
X-Google-Attributes: gidfc256,public
From: "Sanjay" <sgupta@aegonusa.com>
Subject: Slow SQL serverperformance over 56k frame relay
Date: 1997/03/03
Message-ID: <01bc282a$ff59bd60$168f7ba2@sgupta>
X-Deja-AN: 222863706
Organization: MidWest Communications, Inc.
Newsgroups: comp.databases.ms-sqlserver,cz.net.tcpip,microsoft.public.windowsnt.protocol.tcpip,relcom.tcpip