[firebird-support] Bad surprise on performance

2015-01-02 Thread André Knappstein knappst...@beta-eigenheim.de [firebird-support]
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

Re: [firebird-support] Bad surprise on performance

2015-01-02 Thread André Knappstein knappst...@beta-eigenheim.de [firebird-support]
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.

RE: [firebird-support] Bad surprise on performance

2015-01-02 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
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

Re: [firebird-support] Attempt to call GlobalRWLock::unlock() while not holding a valid lock for logical owner

2015-01-02 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 31-12-2014 21:03, sboyd...@gmail.com [firebird-support] wrote: I have just migrated a system from Firebird 1.5 to 2.0.7.13318 running on Windows 2008 R2. I backed up the data using gbak on 1.5. and reloaded it using gbak on 2.0.7. Now on 2.0.7 I am being plagued by: Attempt to call

RE: [firebird-support] Bad surprise on performance

2015-01-02 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
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

Re: [firebird-support] Attempt to call GlobalRWLock::unlock() while not holding a valid lock for logical owner

2015-01-02 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2-1-2015 17:25, sboyd...@gmail.com [firebird-support] wrote: Have you checked the database with gfix? No, I haven't. What options would you suggest? I'd start with a (full) validation. Mark -- Mark Rotteveel

Re: [firebird-support] Attempt to call GlobalRWLock::unlock() while not holding a valid lock for logical owner

2015-01-02 Thread sboyd...@gmail.com [firebird-support]
Have you checked the database with gfix? No, I haven't. What options would you suggest?

Re: [firebird-support] Attempt to call GlobalRWLock::unlock() while not holding a valid lock for logical owner

2015-01-02 Thread sboyd...@gmail.com [firebird-support]
Did a gfix -v -f -n and no problems were reported.

Re: [firebird-support] Bad surprise on performance

2015-01-02 Thread André Knappstein knappst...@beta-eigenheim.de [firebird-support]
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

Re: [firebird-support] Bad surprise on performance

2015-01-02 Thread André Knappstein knappst...@beta-eigenheim.de [firebird-support]
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

Re: [firebird-support] Re: Bad surprise on performance

2015-01-02 Thread André Knappstein knappst...@beta-eigenheim.de [firebird-support]
Hello Vlad, It is sure Raid 0 with 3 * 600 GB Toshiba SAS. I only installed the server today. I did not use the LSI Raid BIOS for configuration but the server view installation kit from the producer. So I will have to look up stripe size and BBU status. Next week I will also apply a

Re: [firebird-support] Bad surprise on performance

2015-01-02 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
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

[firebird-support] Re: Bad surprise on performance

2015-01-02 Thread hv...@users.sourceforge.net [firebird-support]
Hi, André ! [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 *

Re: [firebird-support] Bad surprise on performance

2015-01-02 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]
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