Subject Re: [firebird-support] Re: Classic server uses a lot of memory depending on client connection
Author Thomas Steinmaurer
>> Query MON$MEMORY_USAGE. Perhaps there is something obvious in there.
>>
>>
>>
>> --
>> With regards,
>>
>> Thomas Steinmaurer
>
> I have query that table and i get
>
> MON$STAT_ID 6
> MON$STAT_GROUP 1
> MON$MEMORY_USED 42481128
> MON$MEMORY_ALLOCATED 83783680
> MON$MAX_MEMORY_USED 42712924
> MON$MAX_MEMORY_ALLOCATED 83984384

Well, if this is the only record available, then it simply tells you the
memory allocated and used for an attachment (MON$STAT_GROUP = 1).

What's your page size and page buffers value at database-level?


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