Subject Re: Performance Degrade - HELP
Author Alexander V.Nevsky
--- In, Rajesh Punjabi <rajesh@i...>
> The memory shoots up when the user connects to the server not when
> first statement fires. I ran a timing test to detect this.

Hmm, if Helen's suspictions are right and you really use CS server,
check if cashe buffers is'nt set inside database via gfix to large
value suitable to SS, something about 10000. This setting overrides
configuration parameter. And then check if it is not specified among
client connection parameters, this override both conf and database

> I presume your db of 6GB is multiple files ... how many files ? How
> dbpages per file ? Can you let me know ? Is it hosted on WinNT or

Database page is 8K, I have instances on FB1 CS 4 files (3 by 250000
pages and last about 30000 pages), upgraded RH7.1, kernel 2.4.9 smp,
glibc 2.2.4, and one-file instances on FB1.5 CS RC6, RH8.0, kernel
2.4.20, glibc 2.3.2. No problems.

> ? Maybe I need to split my db into multiple files to solve the
problem ?

Do'nt think so.

> I am using (2.18-4).

Can say nothing about this one. Heared some kernels do'nt release
file cashe until RAM is required for another needs, but IIRC this was
about last ones, from RH9.?.

Best regards,