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

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

Tracing route to over a maximum of 30 hops

1 <1 ms <1 ms <1 ms

2 <1 ms <1 ms <1 ms

3 21 ms 23 ms 24 ms

4 13 ms 13 ms 13 ms

5 13 ms 13 ms 13 ms

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


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.

CreatePlease login to create content