--- In firebird-support@yahoogroups.com, Jason Dodson <jasond@b...>
wrote:

>
> 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.

The figures are from Task Manager, and AFAIK there are no other
importent processes running simultaneously. In my 5.5 years of
running IB/Firebird I've never seen memory figures evolving like this
one . . .

> 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.

>