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 > > >> ------------------------------------ >> ------------------------------------ >> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ >> Visit http://www.firebirdsql.org and click the Documentation item >> on the main (top) menu. Try FAQ and other links from the left-side menu >> there. >> Also search the knowledgebases at >> http://www.ibphoenix.com/resources/documents/ >> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ >> ------------------------------------ >> Yahoo Groups Links > > > > > ------------------------------------ > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > > Also search the knowledgebases at > http://www.ibphoenix.com/resources/documents/ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > ------------------------------------ > > Yahoo Groups Links > > > > > -- Atenciosamente, Hugo Eyng ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/