On 05/20/2012 07:45 AM, Aaron Burnett wrote:
Hey Steve,
Just wanted to send a note of thanks for pointing me in a few new
directions on this.
Turns out that the query would swap but not all the time. When it swapped,
it wouldn't finish, if it didn't swap it would finish in the expected
time. No
Aaron Burnett wrote:
>>> I run a handful of queries overnight when traffic is at it's lowest
on our
>>> system. One particular query will run perfectly fine (around 5
seconds0)
>>> for several weeks, then suddenly decide to hang indefinitely and
never
>>> finish. It needs to be killed manually afte
On 05/18/2012 11:01 AM, Aaron Burnett wrote:
... One particular query will run perfectly fine (around 5 seconds)
for several weeks, then suddenly decide to hang indefinitely and never
finish
Is the machine busy processing the query or is it idle?
It is processing and in fact drives the loa
Thanks Steve,
Answers are inserted below:
On 5/18/12 11:09 AM, "Steve Crawford"
wrote:
>On 05/18/2012 09:17 AM, Aaron Burnett wrote:
>> Greetings,
>>
>> I run a handful of queries overnight when traffic is at it's lowest on
>>our
>> system. One particular query will run perfectly fine (around
On 05/18/2012 09:17 AM, Aaron Burnett wrote:
Greetings,
I run a handful of queries overnight when traffic is at it's lowest on our
system. One particular query will run perfectly fine (around 5 seconds)
for several weeks, then suddenly decide to hang indefinitely and never
finish. It needs to be
Greetings,
I run a handful of queries overnight when traffic is at it's lowest on our
system. One particular query will run perfectly fine (around 5 seconds)
for several weeks, then suddenly decide to hang indefinitely and never
finish. It needs to be killed manually after several hours (I've
int
