
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