Hello Michael,

> * What is the page buffers value at database level? (gstat -h)
> E:\DB\Kaufmann>"c:\Program Files\Firebird\Firebird_2_5\bin\gstat.exe"
> localhost:
> e:\db\Kaufmann\OCCEasyPos.FDB -h
>
>
> Database "e:\db\Kaufmann\OCCEasyPos.FDB"
> Database header page information:
> Flags 0
> Checksum 12345
> Generation 101077117
> Page size 4096
> ODS version 11.2
> Oldest transaction 96356704
> Oldest active 96356705
> Oldest snapshot 96356705
> Next transaction 96384172
> Bumped transaction 1
> Sequence number 0
> Next attachment ID 4930121
> Implementation ID 26
> Shadow count 0
> Page buffers 2048
> Next header page 0
> Database dialect 1
> Creation date Nov 11, 2013 23:47:15
> Attributes force write
>
>
> Variable header data:
> Sweep interval: 0
> *END*

Ok, so at least you are not running with a page buffers value of 0 which maps to a default value in firebird.conf of 75 for CS/SC.

Beside your gbak restore issue, your counters here show some interesting throughput numbers, when taking the creation date of the database into account:

~ 170 transactions / sec
~ 9 connections / sec

Especially opening 9 physical connections per second sounds a bit like a design flaw adding unnecessary overhead.

And a 96GB database with a page size of 4K might result in index depth > 3 for larger tables.

> E:\DB\Kaufmann>
>
>
>
>
>
>
>
>
>
>
> * How does your gbak restore call look like?
>
> GBak -C -User %1 -Pas %2 G:\FBDump\OCCEasyPos.fbk
> "LocalHost:F:\DB\Kaufmann\Uddannelse\OCCEasyPos.fdb" -v -rep -o
> -FIX_FSS_METADATA ISO8859_1 -fix_fss_data ISO8859_1 -y
> "G:\FBDump\RestoreEasyPos.txt"

- Any special reason that you use both -FIX* options everytime for the restore?
- Where is the restore process stuck? Probably while creating indexes?
- I would seriously look into running gbak for both, backup and restore through the Services Manager. Check out the -se option

Just some hints, but I don't have a real answer for your SS vs. SC issue.


--
With regards,
Thomas Steinmaurer
http://www.upscene.com

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.