Subject | Server configuration |
---|---|
Author | guido.klapperich@t-online.de |
Post date | 2001-10-04T19:42:59Z |
My DB has a Pagesize of 4096 and my page buffer is 8192, then my
DB-Cache is 32 MB, right ? What does this mean exactly ? Does it mean,
that at the first connection to the DB 32 MB will be reserved in the RAM
or is the DB-Cache just a max Value ?
I have seen, that all entries in my ibconfig are marked as comment, is
this normal ?
Has someone experience with the SERVER_WORKING_SIZE_MIN and
SERVER_WORKING_SIZE_MAX parameters in the ibconfig ? I have set
SERVER_WORKING_SIZE_MIN to 128 MB and SERVER_WORKING_SIZE_MAX to 512 MB,
because I hoped, that IB will reserve 128 MB RAM at startup, but is
doesn't.
The reason for my questions is the following: I have a SP, which
execution takes more than a hour. While executing the SP IB permanently
accesses the harddrive, but not more than 30 MB RAM are used by IB.
Therefore I want to force IB to take more RAM, but I don't know, how to
do so.
Can anybody help me ?
Guido
DB-Cache is 32 MB, right ? What does this mean exactly ? Does it mean,
that at the first connection to the DB 32 MB will be reserved in the RAM
or is the DB-Cache just a max Value ?
I have seen, that all entries in my ibconfig are marked as comment, is
this normal ?
Has someone experience with the SERVER_WORKING_SIZE_MIN and
SERVER_WORKING_SIZE_MAX parameters in the ibconfig ? I have set
SERVER_WORKING_SIZE_MIN to 128 MB and SERVER_WORKING_SIZE_MAX to 512 MB,
because I hoped, that IB will reserve 128 MB RAM at startup, but is
doesn't.
The reason for my questions is the following: I have a SP, which
execution takes more than a hour. While executing the SP IB permanently
accesses the harddrive, but not more than 30 MB RAM are used by IB.
Therefore I want to force IB to take more RAM, but I don't know, how to
do so.
Can anybody help me ?
Guido