It is possible that you are looking at currently in-memory allocation. Look at the virtual memory allocation for the
process and see if maybe it all got swapped out.

Jason

bjorgeitteno wrote:

> (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
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>

--
The information transmitted herewith is sensitive information intended only for use to the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon, this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.