Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

SQL's application time out

We have an application base on SQL, this application is provided by server throught a private WAN link with maximun capacity of 2Mbps current usages is 800Kbps. We are experimenting problem with application time out and we have solved it adjusting the MTU parameters in each station to 1460 bytes. The connection to SQL servers start in our WS6509 using ethernet which use as MTU to 1500 by default, but so far from this L3 switch is a cloud for me, because this equipments are other owner's administrators.

Here is a traceroute

C:\Documents and Settings\xxxx>tracert 192.168.239.194

Tracing route to 192.168.239.194 over a maximum of 30 hops

1 <1 ms <1 ms <1 ms 10.32.6.200

2 <1 ms <1 ms <1 ms 10.32.0.101

3 21 ms 23 ms 24 ms 192.168.252.1

4 13 ms 13 ms 13 ms 192.168.239.2

5 13 ms 13 ms 13 ms 192.168.239.194

The connectivity was working fine recentetly and we are frustated to have to solve in this way this problem because I know that is uncommon solutions because the degradation in efficiency for TCP connections.

My question for you is that if changing the MTU parameters in each station (which is not scalable) should be the solution or there is (are) other ones that I can follow.

Thanks in advanced

1 REPLY
Bronze

Re: SQL's application time out

I think you have to change the MTU parameters in each station.When the database server processes a large query, you might want to prompt the user periodically to determine whether to continue the request.

193
Views
0
Helpful
1
Replies
CreatePlease login to create content