Subject | DB Stats - Header Page |
---|---|
Author | Kevin Stanton |
Post date | 2010-04-14T15:22:32Z |
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
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