Hi,

We've got a FB 2.1 database that's becoming a bit large (34 Gbyte, two
of the tables with 100 million records each).

It has happened a couple of times that a usually rather quick query took
two hours to execute, during which I could see memory usage go up, up,
up, slowly but steadily.

Is this a sweep going on? Or a garbage collect?

How can I see what's going on?

This is FB 2.1 64 bit on Win 64 bit.

Regards,
Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64