MS SQL Server - Time out expired

Author

Time out expired

sid_hegde@irco.com

2006-02-13, 7:23 am

We have been getting timeouts intermittently with our application. The
time out expired appears to be a random occurance and we are not able
to replicate the issue on a consistent basis. In most instances the
time outs are happening with SELECT statements and after a few minutes
it seems to go away.
Our connection & command time out is set to 30 seconds. This has been
working pretty good for quite sometime and this timeout issue has
started occurring in the past couple of months on a fairly regular
basis. As far as I know we had no change in our hardware or software
setup.

We have the following setup
Application developed in VB 6.0 enterprise edition, SP 6
ADO 2.8
SQL Server 2000, SP 4
Deployed on Citrix servers, metaframe presentation server ver 4.0

A couple of things that we have done are
1. Ensured that all tables have primary keys and indexes
2. No packet drop from our app. to sql server

Can you please give me hints to troubleshoot this issue.

Thanks !!!
Sid Hegde

Jens

2006-02-13, 7:23 am

Did you make sure that your connection pool are configured if you are
using anyone ? Otherwise the connections wil be queued until one
connection closes.

HTH, jens Suessmeyer.

Dan Guzman

2006-02-13, 7:23 am

The most common cause of query timeouts are poor query performance, blocking
or both. It is likely that blocking is the immediate problem since the
problem is intermittent. You can execute sp_who during slow periods to see
if that's the issue.

Tuning can help mitigate blocking problems. If the amount of data are
growing, you might need to revisit index tuning. This would explain why the
problem is occurring more often now.

--
Hope this helps.

Dan Guzman
SQL Server MVP

<sid_hegde@irco.com> wrote in message
news:1139828921.838832.293600@f14g2000cwb.googlegroups.com...
> We have been getting timeouts intermittently with our application. The
> time out expired appears to be a random occurance and we are not able
> to replicate the issue on a consistent basis. In most instances the
> time outs are happening with SELECT statements and after a few minutes
> it seems to go away.
> Our connection & command time out is set to 30 seconds. This has been
> working pretty good for quite sometime and this timeout issue has
> started occurring in the past couple of months on a fairly regular
> basis. As far as I know we had no change in our hardware or software
> setup.
>
> We have the following setup
> Application developed in VB 6.0 enterprise edition, SP 6
> ADO 2.8
> SQL Server 2000, SP 4
> Deployed on Citrix servers, metaframe presentation server ver 4.0
>
> A couple of things that we have done are
> 1. Ensured that all tables have primary keys and indexes
> 2. No packet drop from our app. to sql server
>
> Can you please give me hints to troubleshoot this issue.
>
> Thanks !!!
> Sid Hegde
>

Anith Sen

2006-02-13, 9:23 am

You might want to check out:
http://vyaskn.tripod.com/watch_your_timeouts.htm

--
Anith

Sponsored Links