Query Time Out Phenomenon 
Author Message
 Query Time Out Phenomenon
I have an app that runs for about 14 hours straight and then all of a
sudden its queries start timing out.  I tried shutting down the app,
including warm and cold reboots of the app machine, and the time outs
continue.  I stumble across the fact that if I run the query in SQL
Query Analyzer it takes a little time and then all of sudden
everything starts working again for another 14 hours.

Has anyone else seen this phenomenon before or does anyone have a clue
as to what might be going on?

Greg



Sat, 22 May 2004 05:40:51 GMT
 Query Time Out Phenomenon

Check for your database space allocated, and increase the size if needed.

Paul


Quote:
> I have an app that runs for about 14 hours straight and then all of a
> sudden its queries start timing out.  I tried shutting down the app,
> including warm and cold reboots of the app machine, and the time outs
> continue.  I stumble across the fact that if I run the query in SQL
> Query Analyzer it takes a little time and then all of sudden
> everything starts working again for another 14 hours.

> Has anyone else seen this phenomenon before or does anyone have a clue
> as to what might be going on?

> Greg



Tue, 15 Jun 2004 04:07:31 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. query time outs! please help

2. Time Outs When running a query

3. Continual time-outs (time is not on my side)

4. MS SQL Server 2000 time-outs periodicly over the internet

5. Time outs

6. Time-outs that didn't happen under NT4sp6

7. Time outs!

8. Time-outs on only 2 of many stored procedures

9. Distribution Agent Time Outs

10. Performance trouble, time outs

11. Setting Time Outs

12. MS SQL Server 2000 time-outs periodicly over the internet


 
Powered by phpBB® Forum Software