Re: [firebird-support] Bad surprise on performance
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
Re: [firebird-support] Bad surprise on performance
Hi Andre, - get some sleep This is the key to find a solution, never optimize anything in a bad mood :) WinSrv2008R2 is a perfect Windows Server, when properly configured. Regards, Alexey ++ 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/
Re: [firebird-support] Bad surprise on performance
Thank you for the prompt answer, Sean. But, no, I have read about this specific one. And though I am sure I did not fully understand about it yet, since my biggest database is only 1 GByte I *thought* this would not be a problem for me. = Ihre Nachricht: 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. [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 Let me guess, you database is larger than 8GB (or 16GB in size)? The problem is not with Firebird... Your problem is the infamous Windows 64bit File Cache causes excessive Page File usage. There are a large number of posts on this subject in this forum but also on the web. Sean Posted by: Leyne, Sean s...@broadviewsoftware.com ++ 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 * 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/
RE: [firebird-support] Bad surprise on performance
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. [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 Let me guess, you database is larger than 8GB (or 16GB in size)? The problem is not with Firebird... Your problem is the infamous Windows 64bit File Cache causes excessive Page File usage. There are a large number of posts on this subject in this forum but also on the web. Sean
RE: [firebird-support] Bad surprise on performance
Thank you for the prompt answer, Sean. But, no, I have read about this specific one. And though I am sure I did not fully understand about it yet, since my biggest database is only 1 GByte I *thought* this would not be a problem for me. Do you still have access to old server/hardware. If so, I would start by confirming that the problem is not with hardware, by running disk benchmark like Crystal Disk Mark (my personal fav, nice and simple), MS SQLIO or IOMeter. Once you have eliminated hardware, then you can move on to OS configuration/settings then Firebird config. Sean
Re: [firebird-support] Bad surprise on performance
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/
Re: [firebird-support] Bad surprise on performance
Yes, the old system is running. It *is* the current production system of our company and it looks like I'll be glad if it holds on a bit longer :-) Don't know the Crystal Disk Mark. Will check this out for sure! Was trying to get some clue from Process Explorer (the former SysInternals one). Maybe I am lucky and it is just the Raid controller. Thanks! = Ihre Nachricht: Thank you for the prompt answer, Sean. But, no, I have read about this specific one. And though I am sure I did not fully understand about it yet, since my biggest database is only 1 GByte I *thought* this would not be a problem for me. Do you still have access to old server/hardware. If so, I would start by confirming that the problem is not with hardware, by running disk benchmark like Crystal Disk Mark (my personal fav, nice and simple), MS SQLIO or IOMeter. Once you have eliminated hardware, then you can move on to OS configuration/settings then Firebird config. Sean Posted by: Leyne, Sean s...@broadviewsoftware.com ++ 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 * 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/
Re: [firebird-support] Bad surprise on performance
On 3-1-2015 00:14, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: [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 Let me guess, you database is larger than 8GB (or 16GB in size)? The problem is not with Firebird... Your problem is the infamous Windows 64bit File Cache causes excessive Page File usage. There are a large number of posts on this subject in this forum but also on the web. 2.5.2 and higher should no longer be affected by that problem. Mark -- Mark Rotteveel ++ 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/
Re: [firebird-support] Bad surprise on performance
LSSBcfs Your problem is the infamous Windows 64bit File Cache causes excessive Page File usage. Btw, afaik, 2.5.3 should not have this problem with the Windows cache. []s Carlos Firebird Performance in Detail - http://videos.firebirddevelopersday.com www.firebirdnews.org - www.FireBase.com.br
