Subject | [firebird-support] FB GBK and CPU Usage |
---|---|
Author | Andrew Stuart |
Post date | 2008-10-13T10:31:17Z |
Hi All
We are getting really slow DB performance during backups, we're a 24/7
company and so cant run them during a down period.
Gbak runs about 6-10% and FBServer runs a good 50% (dual core box so
flat out on one core)
After gbak has finished the fbserver is still running around 50%
Is this normal?
It's a windows 2003 box with fb 1.5
I think the below isn't right, but im a total 'noob' when it comes to
databases
Any help would be greatly appreciated
Cheers
Andrew
D:\Program Files\Firebird_1_5\bin>gstat -h e:\data\cabs.fdb
Database "e:\data\cabs.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 9959021
Page size 4096
ODS version 10.1
Oldest transaction 8479679
Oldest active 8479680
Oldest snapshot 8378442
Next transaction 9959010
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 3
Creation date Jan 18, 2008 2:31:22
Attributes force write
Variable header data:
Sweep interval: 20000
*END*
Head and Registered Office:
Call Assist Ltd,
Axis Court, North Station Road,
Colchester, Essex.
CO1 1UX
Telephone +44 (0)1206 771771
Fax +44 (0)1206 364268
Registered in England and Wales.
Registered Company Number 3668383
Authorised and regulated by the Financial Services Authority
Please Note : This electronic message contains information from Call Assist Ltd which may be privileged or confidential.
The information is intended for the use of the individual(s) named above. If you are not the intended recipient be aware
that any disclosure, copying, distribution or use of the contents of this information is prohibited.
If you are not the intended recipient please delete this email. If you have received this electronic
message in error, please notify us by telephone or email immediately.
Please consider the environment before printing this email.
[Non-text portions of this message have been removed]
We are getting really slow DB performance during backups, we're a 24/7
company and so cant run them during a down period.
Gbak runs about 6-10% and FBServer runs a good 50% (dual core box so
flat out on one core)
After gbak has finished the fbserver is still running around 50%
Is this normal?
It's a windows 2003 box with fb 1.5
I think the below isn't right, but im a total 'noob' when it comes to
databases
Any help would be greatly appreciated
Cheers
Andrew
D:\Program Files\Firebird_1_5\bin>gstat -h e:\data\cabs.fdb
Database "e:\data\cabs.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 9959021
Page size 4096
ODS version 10.1
Oldest transaction 8479679
Oldest active 8479680
Oldest snapshot 8378442
Next transaction 9959010
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 3
Creation date Jan 18, 2008 2:31:22
Attributes force write
Variable header data:
Sweep interval: 20000
*END*
Head and Registered Office:
Call Assist Ltd,
Axis Court, North Station Road,
Colchester, Essex.
CO1 1UX
Telephone +44 (0)1206 771771
Fax +44 (0)1206 364268
Registered in England and Wales.
Registered Company Number 3668383
Authorised and regulated by the Financial Services Authority
Please Note : This electronic message contains information from Call Assist Ltd which may be privileged or confidential.
The information is intended for the use of the individual(s) named above. If you are not the intended recipient be aware
that any disclosure, copying, distribution or use of the contents of this information is prohibited.
If you are not the intended recipient please delete this email. If you have received this electronic
message in error, please notify us by telephone or email immediately.
Please consider the environment before printing this email.
[Non-text portions of this message have been removed]