Hi Alan and Helen

When I select in the MON-tables i Can see that all activity in the
ATTACHMENT gives me a characterset of value 0. I suppose that indicates
everybody is using the same charset.

I have tried to set DefaultCache pages to 50 and 150 - same symptom. Also
with the lochHashSlot set to 2039.

When I open my application its rapidly increases to 95Mb and if I use
another function its just increasing the use of memory.

I have now tried the Firebird.Conf:
as standard - same symptom
DefaultCachePages to 50, 128, 150, 512, 1024, 2048 - same symptom.

the Database has a page size of 8192.

Please advice, what to do next. Are running out of ideas. Is there any
settings server side on windows to set maximize each process Menory use? Or
on the Firebird Server itself?

For each change I have just restarted the Firebird Service and made a
"taskkill /F IM fb_inet_server.exe /T". Is it necessary to restrat whole
server for each change?

thanks for any help provided.

Kenneth



2010/6/28 Kenneth Tilsted <kst@...>

> Hi Alan and Helen
>
> When I select in the MON-tables i Can see that all activity in the
> ATTACHMENT gives me a characterset of value 0. I suppose that indicates
> everybody is using the same charset.
>
> I have tried to set DefaultCache pages to 50 and 150 - same symptom. Also
> with the lochHashSlot set to 2039.
>
> When I open my application its rapidly increases to 95Mb and if I use
> another function its just increasing the use of memory.
>
> I have now tried the Firebird.Conf:
> as standard - same symptom
> DefaultCachePages to 50, 128, 150, 512, 1024, 2048 - same symptom.
>
> the Database has a page size of 8192.
>
> Please advice, what to do next. Are running out of ideas. Is there any
> settings server side on windows to set maximize each process Menory use? Or
> on the Firebird Server itself?
>
> For each change I have just restarted the Firebird Service and made a
>
> taskkill /F /IM fb_inet_server.exe /T
>
> Is it necessary to restrat whole server for each change?
>
> thanks for any help provided.
>
> Kenneth
>
>
> Alan McDonald skrev:
>
>>
>> > Hi all Firebird friends
>> >
>> > Have posted this one as well on DEVSHED.COM <http://devshed.com/> but
>> so far no help
>> > received. Will try this forum
>> >
>> > I have a weird problem. A Firebird 2.1.3 Firebird classic database at
>> > customer site where the fb_inet_server.exe process eats up all memory
>> > on server and then continues to use swap file until server crashes.
>>
>> are all users conneccting using the same CHARSET? There is a bug in
>> 2.1.3/4
>> associated with BLOB memory. I am using 2.1.4 snapshot with no issues like
>> this anymore.
>> Alan
>>
>> >
>> > I have many customers with same application but i have only seen this
>> > at 1 customer site. Normally a process will take up between 25-40Mb of
>> > Ram each, but at this customer it is up to 130Mb each process. Its like
>> > it is not freeing up the memory
>> >
>> > The configuration is the same - standard for the databaseserver
>> > installation. The OS is Windows 2003 Std. Edition SP2.
>> >
>> > What am I looking for in order to find out why the processes consumes
>> > so much memory?
>> >
>> > The server has 2xdual core processor. The CPU seems to be OK - around
>> > 20-40% of load.
>> >
>> > It is a new created VMWare instans with 4Gb of Ram but the problem was
>> > exactly the same on a physical server before the change to VMWare.
>> >
>> > Am I looking at Firebird Database Enigine, The database itself or the
>> > OS?
>> >
>> > Can anyone in here help - what info more can I Provide to you.
>> >
>> > Thanks in Advance
>> >
>> > Regards
>>
>>
>>
>
>
>

--
Mvh
Kenneth Tilsted
Support- & Driftschef

Avaleo ApS
Skagensgade 39, 2
2630 H�je-T�strup
Tlf - Kontor: 70104488
Tld - Direkte: 61550076


[Non-text portions of this message have been removed]