>> It looks like you might have a transaction handling problem as well.
>> That will slow down your database. Schedule a sweep at a quiet point in
>> the day.
>>
>>>> Oldest transaction 3220
>>>> Oldest active 16672
>>>> Oldest snapshot 16672
>>
>>
>> Cheers,
>> Norm.
>>
>> Norman Dunbar
>
> Hello Norman, i have no problem with performance, my problem is to know if is correct that fb_inet_server.exe uses near 100MB RAM or is a bug.
>
> After backup and restore, the problem is the same. I connect and execute one stored procedure and fb_inet_server uses a lot of RAM. If for one user uses 100MB, for 200 users i need 200 GB RAM, and i would like to know if is normal.

20GB. ;-)

Are you able to share a metadata backup? ts @ iblogmanager . com



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