Subject DB Stats - Header Page
Author Kevin Stanton
Greetings,

I just took a quick look at the stats and below is what I found. My
customer is complaining of slowness but that could be 1 of a couple
offending reports I need to analyze.

I know the main concern is oldest active transaction - is the gap between
oldest active and next transaction large enough to be concerned about? I do
a backup/sweep every night off hours.

Thanks in advance,
Kevin





Service started at 4/14/2010 8:17:59 AM

Database "d:\fb databases\lumber\lumber.fdb"

Database header page information:
Flags 0
Checksum 12345
Generation 120444
Page size 8192
ODS version 10.1
Oldest transaction 111981
Oldest active 111982
Oldest snapshot 111970
Next transaction 120437
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 Apr 10, 2010 22:48:05
Attributes force write

Variable header data:
Sweep interval: 0
*END*

Service ended at 4/14/2010 8:17:59 AM