> i'm using FB 2.5. There a about 15 users connecting my db. (64 bits)
> After a while the memory goes from 120 Mb to 500 Mb then 15 minuten later to 800 Mb a few minutes later 1Gb 1,5Gb 2Gb until 6Gb after a few hours. And then stops responding.
>
> i did already this query
>
> SELECT * from MON$MEMORY_USAGE
>
> but i get 488 records but i do not understand what too see there

Have you checked out the Firebird 2.5 release notes p.40ff?

There is also the following example: “Top 10” statements ranked
according to their memory usage:


SELECT FIRST 10
STMT.MON$ATTACHMENT_ID,
STMT.MON$SQL_TEXT,
MEM.MON$MEMORY_USED
FROM MON$MEMORY_USAGE MEM
NATURAL JOIN MON$STATEMENTS STMT
ORDER BY MEM.MON$MEMORY_USED DESC


--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!

> wo can help me
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org 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
>
>
>