(FB 1.5.1.4481 server on W2k 1.5GB 4-proc.)

Hi, All !

The problem is as follows: Yesterday, a stored procedure seemingly
halted - that is, it didn't finish in 5 hours while earlier having
finished in 10 minutes.

Finding 1: Processor 2&3 were both running on some ~30%, which is
reasonable when we discovered a CPU affinity mask of 6. Was changed
to 2, and ever since only this processor is utilized (says Task
Manager).

...the service was killed & started again, but at no avail. "Halted"
within the same procedure. Now:

Finding 2: Like normal, a CPU utilization, frenetic disk activity and
increasing memory consumption (some 25MB) in the beginning. After
some 30 seconds, the processor went to 99% and remained so WHILE
MEMORY CONSUMPTION DROPPED BIT BY BIT DOWN TO ~900kB.

What on earth could make FB release most of its memory ? I have never
seen anything like this - on the contrary - a session's memory pool
is never reduced within the session (right ?) !

Any ideas ?

regards
Bjoerge Saether