--- In firebird-support@yahoogroups.com, Vlad Horsun <hvlad@...> wrote:

>
> > > How many databases active at this moment ?
> >
> >
> > 2 active databases.
> > 1 is very small.
> > Contains 1 table with 38 records inside.
> > During a day, this DB has some 200 reads and 50 writes.
> > No insert or deletes.
> >
> > Second DB - Its around 8Gb in size.
> > It has between 50 and 150 users connected.
> > I think I earlier on said some 200+, but as I have been monitoring the
> > last days its "only" 50 to 150 users.
>
> Any chance that many of them run some queries with SORT in plan
> simultaneously ?

If you be this means, that users do a
select f1, f2, etc
from table
Inner join....
where
Conditions...
Order by ....

Then yes - There are times a day when users will do that on the same
time.

>
> > Does some of them have
> > > fixed cache setting ?
> >
> > I don't know what this is.
>
> Show us the output of gstat -h for each database, please

Is this the information you would like to have ?

Database header page information:
Flags 0
Checksum 12345
Generation 13848809
Page size 4096
ODS version 10.1
Oldest transaction 13823495
Oldest active 13823496
Oldest snapshot 13822165
Next transaction 13848701
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 1
Creation date Jun 14, 2006 13:37:55
Attributes force write

Variable header data:
Sweep interval: 20000
*END*


Funny thing though is - I made this with my application.
Calling this:

"c:\Program Files\Firebird\Firebird_1_5\bin\gstat.exe" -h occeasypos.fdb

Returns this error:

unknown Windows NT error 2

Michael

>
> Regards,
> Vlad
>