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

charset 0 means charset NONE.
In my recent experience, that's a problem especially with 2.1.3 and
especially when you are trying to monitor tables.
You will have a memory leak under these cases.
If I were you, I would grab a copy of 2.1.4 snapshot and replace.
Also make the clients use a charset - ISO8859_1 is a good choice. And make
sure ALL connections (including your admin connections) use this (the same
charset).
Alan

I waS experiencing heavy memory loss on my servers until I followed these
changes.
Alan

>
> 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]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>