Time out Problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PhilPeak - 25 Nov 2005 11:34 GMT

Time Out Problem

A single VB application links successfully to an SQL server. The
application calls simple procedures to query the database. After 30s these
queries timeout. If the timeout period is extended, all procedures return
successfully. What is going on?

Background info.

****** Processor activity rarely goes over 4%. *******

Available RAM has been increased from 1G to 3G – problem still remains

Many thanks

Phil

Reply to this Message

Hilary Cotter - 25 Nov 2005 12:34 GMT

You need to look at these stored procedures. Chances are they are not
optimal.

Do they run fine from the console?

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Time Out Problem
>
[quoted text clipped - 13 lines]
>
> Phil

Reply to this Message

PhilPeak - 28 Nov 2005 14:06 GMT

We are running from the console when the timeout occurs. The funny thing is
that the Processor activity is so low whenyou would expect ti to be higher.

> You need to look at these stored procedures. Chances are they are not
> optimal.
[quoted text clipped - 18 lines]
> >
> > Phil

Reply to this Message