Hello.
FB 2.5.3 works (for me) on Win Server 2008 R2 Enterprise 64 bits, and
others version of Win Server 2008 too.
Dell R620 32GB RAM Intel Xeon E-2609.
Hugo
On 02/01/2015 22:08, André Knappstein knappst...@beta-eigenheim.de
[firebird-support] wrote:
Fascinating...
I created a test table on both old and new server to play with updates
and inserts (~ 150.000 records)
Performance with 2.5.3 x64 on Win2008 is constantly
changing, but at best its some 8 seconds and worst even 2 minutes!
Performance with 1.5.4 x86 on Win2003 is always about the same, and
always 2.9 - 3.2 seconds.
My next steps will be:
- get some sleep
- reduce example to a database with only this one testtable
- install 2.5.3 on 2 other new servers (different RAIDs) and test
there
- test also with 2.5.3 CS x86, 2.5.3 SS x64/x86, 1.5.4 CS x86
- fire myself before presenting bill for new server to my boss unless
I find a solution
If somebody *KNOWS* for sure that Firebird just won't work on
Server2008, or if someone knows for sure that it does, please drop a
note.
Query
update X3058000 x
set
x.p3058_004n = (x.p3058_004n * 2)
Plan
PLAN (X NATURAL)
Query Time (new Server))
Prepare : 0,00 ms
Execute : 30.781,00 ms
Avg fetch time: 0,00 ms
Query Time (old Server)
Prepare : 15,00 ms
Execute : 3.110,00 ms
Avg fetch time: 0,00 ms
Memory (new Server)
Current: 10.412.912
Max: 10.504.672
Buffers: 2.048
Memory (old Server)
Current: 5.887.792
Max: 6.158.624
Buffers: 2.048
Operations (new Server)
Read : 2.247
Writes : 5.960
Fetches: 2.476.240
Marks : 807.922
Operations (old Server)
Read : 8.516
Writes : 6.084
Fetches: 1.602.243
Marks : 582.584
mit freundlichen Grüßen,
ppa. André Knappstein
EDV und Controlling
~~
beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH
Hafenweg 4
59192 Bergkamen-Rünthe
Telefon: +49 2389 9240 140
Telefax: +49 2389 9240 150
e-mail: knappst...@beta-eigenheim.de
Amtsgericht Hamm Nr. B 420
Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus
USt-IDNr.: DE 125215402
=
Ihre Nachricht:
Hey! Happy new year to all!
For me, it should have started with something great, new...
FINALLY! The migration from FB 1.5 to 2.5 (trust me, I had reasons not
to do it earlier). But now the old appications are all gone, and I can
migrate.
Seems there will be a delay. I migrated the database from old hardware
running 1.5.4 to new hardware running 2.5.3. Backup/Restore is about 4
times faster. Wow!
But normal working is - at least - 50% slower sometimes worse.
I already scanned the newsgroups and noticed that other users had the
same problem, but none of them seems to have found a good solution.
For me - being only a part time wannabe administrator - I really don't
have a clue where to start looking.
Here are some details of the 2 systems; if anybody can point me into a
direction where to look first it would be most welcome.
[Old]
Server 2003 x86 no service packs
Xeon with 4 GB RAM
Classic 1.5.4 (x86, of course)
Raid 0 on 2 * 500 GB SAS (though this is from memory, I should look it
up...)
[new]
Server 2008 R2 x64 SP1
Xeon with 8 GB RAM (I will shortly add +8)
Classic 2.5.3 x64
Raid 0 on 3 * 600 GB SAS
In comparison to what I read from others, my databases are small.
Biggest database is some 1 GB only.
Bad performance on updates and inserts and extremely bad performance
on committing a big number of record changes (~ 150.000 updates).
Database has 4096 Page Size and 2048 buffers (which sounds like
setting for SS but I specifically set it higher to use more RAM
according to a hint from experts).
While testing the configuration, nobody is in the network.
Firebird runs on dedicated server (just windows and Firebird).
where to look?
mit freundlichen Grüßen,
ppa. André Knappstein
EDV und Controlling
~~
beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH
Hafenweg 4
59192 Bergkamen-Rünthe
Telefon: +49 2389 9240 140
Telefax: +49 2389 9240 150
e-mail: knappst...@beta-eigenheim.de
Amtsgericht Hamm Nr. B 420
Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus
USt-IDNr.: DE 125215402