Subject | Re: [firebird-support] Re: Classic server uses a lot of memory depending on client connection |
---|---|
Author | Thomas Steinmaurer |
Post date | 2011-05-18T21:37:54Z |
>> Query MON$MEMORY_USAGE. Perhaps there is something obvious in there.Well, if this is the only record available, then it simply tells you the
>>
>>
>>
>> --
>> 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
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!