Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Then, If it were only a firebird issue, all of us would have the problem. If some of us has the problem, may be an incompatibility between FB, OS and hardware. Perhaps, if we share information about our environments, the common origin of the problem would arise. Jesus Angel Garcia Zarco Cointec
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Hello Jesus Garcia, Then, If it were only a firebird issue, all of us would have the problem. If some of us has the problem, may be an incompatibility between FB, OS and hardware. Perhaps, if we share information about our environments, the common origin of the problem would arise. Jesus Angel Garcia Zarco Cointec and here is a nice list of information to provide http://ib-aid.com/articles/item157 -- Mit freundlichen Grüssen Hannes Streichermailto:hstreic...@gmx.de ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ 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: http://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Hello. You are not the only one having these problems. I am facing exactly the same problem and nobody could help me in an efective way. Hugo Em 16/02/2014 09:15, Roland Turcan escreveu: Hello all again, I have met more computers with Windows 2008 R2 64bit where the performance is very bad. I was importing into database about 80 GB files into tables with blob fields I had to use for server casual Windows 7 32bit computer to get it done on time. How can it be, that Intel i3 with 4GB RAM 32bit is 6 times faster that multi CPU Xeon server. Every core was 100% busy when executing SQL statements. Of course I set all recommendation in database and firebird.conf but the server is still relaxing. Actually I am working with database about 35GB and again the same problem with bad performance. I am using Classic server 2.5.2 with DBCachePages = 1024 (in DV and firebird.conf) and FileSystemCacheSize = 20, but the CPU is having holiday. I don't believe that I am the only one having these problems. Help me please to force the performance. Best regards, Roland Turcan 23.01.2014 19:23 - Hugo Eyng hugoe...@msn.com I use SuperClassic and seted the DefaultDbCachePages = 2250 The Default value is 75 Than I used a multiple of 75 The amount of memory used by FB service increases a lot and the performance increases too Em 23/01/2014 02:52, Alexey Kovyazin escreveu: Hi Roland, I have tried to change this parameter (actually =20), but I don't see any change. 20? It is below all meaningful values. If you are using SuperServer, set 1, if Classic or SuperClassic, set 1024, and _restart_ Firebird. What else can I test? If you are interested in professional optimization (http://ib-aid.com/services/optimization), contact our support. Regards, Alexey Kovyazin www.IBSurgeon.com http://www.IBSurgeon.com AFAIK, the parameter DefaultDbCachePages is intended for newly created databases as default size of cache pages. It doesn't have effect on existing databases where its own setting is used. Every database can have own setting about count of cache pages. It seems to be still not solving this problem using by FileSystemCacheSize. What else can I test? Thanks. 22.01.2014 15:05 - Hugo Eyng hugoe...@msn.com mailto:hugoe...@msn.com Try changing values for DefaultDbCachePages Em 21/01/2014 18:40, Roland Turcan escreveu: I have tried to change this parameter (actually =20), but I don't see any change. My server box is: Hewlett Packard server Intel Xeon CPU E31220 @ 3.10GHx 10GB RAM (8 GB RAM is usable) Firebird 2.5.2 64bit SuperServer single database is being used where its size is about 80GB When I copy any big file to test the performance of disk field then I can see that it can force disk performance, but Firebird is still relaxing. When I try to backup database using gbak no change. CPU core is on 3-6% and disk load is about 1MB/s What can I check else? Thanks in advance. TRoland; 21.01.2014 15:17 - Hugo Eyng hugoe...@msn.com mailto:hugoe...@msn.com I changed the paramter FileSystemCacheSize = 0 to FileSystemCacheSize = 20 in the firebird.conf as suggested in: http://dyemanov.blogspot.com.br/2012/03/firebird-vs-windows-file-system-caching.html Hugo Em 21/01/2014 12:06, Roland Turcan escreveu: Yes, I am interested too. What was the key to get rid of this problem? Thanks in advance. 21.01.2014 15:29 - Fabiano - Desenvolvimento SCI fabi...@sci10.com.br mailto:fabi...@sci10.com.br How you solved your problem? *De: *firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com[mailto:firebird-support@yahoogroups.com] *Em nome de *Hugo Eyng *Enviada em:* terça-feira, 21 de janeiro de 2014 10:24 *Para: *firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com *Assunto:* Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2 Hi Helen. Thanks for your answer. You are right. But the Windows 64 file cache performance was a problem, as said Sean. Só 'reserving' 10GB as a RAM DRIVE grant that I would have always available RAM. But now I solved the 'cache performance' and I will not need RAM DRIVE anymore. Even so, the FB performance is not compatible to the hardware used to run it. Em 20/01/2014 23:12, Helen Borrie escreveu: At 02:01 p.m. 21/01/2014, Hugo Eyng wrote: As Firebird do not use available RAM I created a RAM DRIVE with 10GB and pointed parameter 'TempDirectories' (firebird.conf) to this RAM DRIVE, but FB just uses it rarely in very big 'SELECT'. OK, when FB uses the RAM DRIVE it increases a SELECT speed in more than 80%. I expected FB could use this for every SELECTS and so improve the application. Fb uses RAM directly for sorts, if enough is available. It only takes the sort sets to disk if available RAM is insufficient. Helen Borrie, Support Consultant, IBPhoenix (Pacific) Author of The Firebird Book
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Hi, I suppose we all have our opinions. This is not an opinion, this is statement, confirmed by our 12 years experience with Firebird and 5 years with Win 2008. Your problem with Win2008 is lack of knowledge, that's all, sorry for the truth. And I'm not going to offer such technical support for free in this support list, sorry. Try other Firebird service providers: http://www.firebirdsql.org/en/professional-support/ may be they have free time. Regards, Alexey Kovyazin IBSurgeon
RE: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Hi, I suppose we all have our opinions. This is not an opinion, this is statement, confirmed by our 12 years experience with Firebird and 5 years with Win 2008. Your problem with Win2008 is lack of knowledge, that's all, sorry for the truth. And I'm not going to offer such technical support for free in this support list, sorry. Try other Firebird service providers: http://www.firebirdsql.org/en/professional-support/ may be they have free time. Regards, Alexey Kovyazin IBSurgeon [Marius Labuschagne] What you doing in this forum Alexey? As far as I am aware this is a support forum, am I wrong? You promoting your business over here with all your years of experience? (Or at least you must be thinking that 12 is a very high number) Lets leave it at that, I would not dare ask you for any support anyway. Regards Marius
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Hi Marius, Sorry, I don't want to be rude. I just want to point that there is no problem with Windows 2008 R2, and a bit tired with all the same questions (with the same answers). Our largest customers databases are on Win2008R2, and it works just fine - 500+ users and 150Gb, 440Gb with 50 users, etc, etc. And, btw, 440Gb is running at the server in Port Elizabeth. Regarding promotion of our business - there are very few professional service providers listed on the Firebirdsql.org, and they are also Firebird sponsors. Without our sponsorship Firebird would not exists and all users would sit with InterBase 6.0, as it was released by Borland in 2000. Regards, Alexey Kovyazin IBSurgeon Hi, I suppose we all have our opinions. This is not an opinion, this is statement, confirmed by our 12 years experience with Firebird and 5 years with Win 2008. Your problem with Win2008 is lack of knowledge, that's all, sorry for the truth. And I'm not going to offer such technical support for free in this support list, sorry. Try other Firebird service providers: http://www.firebirdsql.org/en/professional-support/ may be they have free time. Regards, Alexey Kovyazin IBSurgeon */[Marius Labuschagne] /* */What you doing in this forum Alexey? As far as I am aware this is a support forum, am I wrong? You promoting your business over here with all your years of experience? (Or at least you must be thinking that 12 is a very high number)/* */Lets leave it at that, I would not dare ask you for any support anyway./* *//* */Regards/* */Marius/*
RE: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
I second this answer. Regards, Bogdan MordiCom d.o.o. i...@mordicom.si +386 (05) 33 00 360 From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Alexey Kovyazin Sent: Tuesday, February 18, 2014 3:01 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2 Hi Marius, Sorry, I don't want to be rude. I just want to point that there is no problem with Windows 2008 R2, and a bit tired with all the same questions (with the same answers). Our largest customers databases are on Win2008R2, and it works just fine - 500+ users and 150Gb, 440Gb with 50 users, etc, etc. And, btw, 440Gb is running at the server in Port Elizabeth. Regarding promotion of our business - there are very few professional service providers listed on the Firebirdsql.org, and they are also Firebird sponsors. Without our sponsorship Firebird would not exists and all users would sit with InterBase 6.0, as it was released by Borland in 2000. Regards, Alexey Kovyazin IBSurgeon Hi, I suppose we all have our opinions. This is not an opinion, this is statement, confirmed by our 12 years experience with Firebird and 5 years with Win 2008. Your problem with Win2008 is lack of knowledge, that's all, sorry for the truth. And I'm not going to offer such technical support for free in this support list, sorry. Try other Firebird service providers: http://www.firebirdsql.org/en/professional-support/ may be they have free time. Regards, Alexey Kovyazin IBSurgeon [Marius Labuschagne] What you doing in this forum Alexey? As far as I am aware this is a support forum, am I wrong? You promoting your business over here with all your years of experience? (Or at least you must be thinking that 12 is a very high number) Lets leave it at that, I would not dare ask you for any support anyway. Regards Marius --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Hi folks, Alexey might be referring to us as we also had some performance issues under Win2008R2 and FB 252 SS, but we started a different thread, so I might as well be wrong. Anyway we are still in the process of evaluating the impact of our resolving actions on performance. The operator company rebuilt the server from scratch and we have also changed the application logic a bit, but nothing really changed seriously on either side. We aimed to satisfy the needs and satisfaction of the client and therefore we do not want to change or have any impact on the system that might alter the performance negatively yet. We try to suspend this status quo for some time. More to come on the issue and hopefully the cause and resolution, I ask for Your patience. Regarding Alexey's support. I personally asked for Alexey's help and although we have not got into deep system analysis I must say that during the negotiating process Alexey's attitude was way superior, he was fast at reply, helpful and professional. I am sure we will be happy collaborating on other issues in the future. Regards Zsolt *From:* firebird-support@yahoogroups.com [mailto: firebird-support@yahoogroups.com] *On Behalf Of *Alexey Kovyazin *Sent:* Tuesday, February 18, 2014 3:01 PM *To:* firebird-support@yahoogroups.com *Subject:* Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2 Hi Marius, Sorry, I don't want to be rude. I just want to point that there is no problem with Windows 2008 R2, and a bit tired with all the same questions (with the same answers). Our largest customers databases are on Win2008R2, and it works just fine - 500+ users and 150Gb, 440Gb with 50 users, etc, etc. And, btw, 440Gb is running at the server in Port Elizabeth. Regarding promotion of our business - there are very few professional service providers listed on the Firebirdsql.org, and they are also Firebird sponsors. Without our sponsorship Firebird would not exists and all users would sit with InterBase 6.0, as it was released by Borland in 2000. Regards, Alexey Kovyazin IBSurgeon Hi, I suppose we all have our opinions. This is not an opinion, this is statement, confirmed by our 12 years experience with Firebird and 5 years with Win 2008. Your problem with Win2008 is lack of knowledge, that's all, sorry for the truth. And I'm not going to offer such technical support for free in this support list, sorry. Try other Firebird service providers: http://www.firebirdsql.org/en/professional-support/ may be they have free time. Regards, Alexey Kovyazin IBSurgeon *[Marius Labuschagne] * *What you doing in this forum Alexey? As far as I am aware this is a support forum, am I wrong? You promoting your business over here with all your years of experience? (Or at least you must be thinking that 12 is a very high number)* *Lets leave it at that, I would not dare ask you for any support anyway.* *Regards* *Marius* -- http://www.avast.com/ This email is free from viruses and malware because avast! Antivirusna zaščita http://www.avast.com/ protection is active.
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
'So the only effective solution seems to disable the random access request (i.e. remove the FILE_FLAG_RANDOM_ACCESS flag) from the Windows API calls used to create/open the files. Moreover, in this case the file-system cache size limit should not be actual anymore, as Windows won't be expanding the cache out of the reasonable boundaries. The quick tests prove this solution being workable.' ... 'Taking this into account, as well as the experience of other databases, this solution has been committed into Firebird 2.1.5, Firebird 2.5.2 and Firebird 3.0 branches.' This made me assume this issue wasn't the cause of our problems. However by the sounds of it the fix might not be working. We are using Windows 2008 R2 64 bits, with databases around 35 Gb, and we solved the performance problems with FB 2.5.2. We tested it before and after apply the patch in 2.5.2 versión and verify that the problems was gone. I thin you have to look up in other direction.
RE: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
'So the only effective solution seems to disable the random access request (i.e. remove the FILE_FLAG_RANDOM_ACCESS flag) from the Windows API calls used to create/open the files. Moreover, in this case the file-system cache size limit should not be actual anymore, as Windows won't be expanding the cache out of the reasonable boundaries. The quick tests prove this solution being workable.' ... 'Taking this into account, as well as the experience of other databases, this solution has been committed into Firebird 2.1.5, Firebird 2.5.2 and Firebird 3.0 branches.' This made me assume this issue wasn't the cause of our problems. However by the sounds of it the fix might not be working. We are using Windows 2008 R2 64 bits, with databases around 35 Gb, and we solved the performance problems with FB 2.5.2. We tested it before and after apply the patch in 2.5.2 versión and verify that the problems was gone. I thin you have to look up in other direction. [Marius Labuschagne] We have sites running Windows 2008 R2 64bits (Xeon Quad Core E31220 @ 3.1 Ghz) , with much smaller databases (2-4GB Range), and on Firebird Super Server 2.5.2, and I can tell you that that platform is definitely much much slower in performance than just a simple I3 desktop pc with 8GB of RAM on the exact same database, running Windows 7 Pro or Windows 8 Pro, either 32- or 64-bit. I think you are very lucky Jesus that your problem was solved by 2.5.2 Example: Executing the Month-End in our application, exact same database: - On a Win 2008 R2 64-bit Xeon Machine with 8GB RAM: 55 Minutes - On a Win 7 Pro 64-bit I3 machine with 8GB RAM: 9 Minutes For that specific platform 2.5.2 has not done anything for the performance issue. I suppose we are also lucky that our Clients database is not larger than the physical RAM present at this point in time, hopefully once they do get there I will be able to convince the Client that just using a desktop computer with a standard desktop operating system, is the way to go. My 2c Regards Marius
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Hi All, Hereby I notify everyone that Windows 2008R2 has NO performance issues with Firebird databases till 200Gb in size, and not so many after this size. In all cases when you see performance degradation at Win2008R2 and everything is smooth on Linux/Win7/etc - it is not an OS fault, it's a problem with configuration (incl. version) of Firebird and OS (incl. drivers and domain controllers), or performance problems in your own code (in 80% it's long-running transactions). Regards, Alexey Kovyazin IBSurgeon PS Btw, guys who started the topic already fixed the problem. I hope they will provide more details who they achieved it. */ /*
RE: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Hi All, Hereby I notify everyone that Windows 2008R2 has NO performance issues with Firebird databases till 200Gb in size, and not so many after this size. In all cases when you see performance degradation at Win2008R2 and everything is smooth on Linux/Win7/etc - it is not an OS fault, it's a problem with configuration (incl. version) of Firebird and OS (incl. drivers and domain controllers), or performance problems in your own code (in 80% it's long-running transactions). Regards, Alexey Kovyazin IBSurgeon PS Btw, guys who started the topic already fixed the problem. I hope they will provide more details who they achieved it. [Marius Labuschagne] Hi Alexey, I suppose we all have our opinions. I do not agree with yours though, as out of the box installs of Firebird, no tweaked configurations for Firebird, performs well on all configurations and OS's I have tried, except on Win 2008 R2. The machine in question is not a domain controller, so its not that. Performance problems with your own code, laughing at this, as the same problem will present itself on other platforms then as well, especially if the platforms compared is presenting the problem on the supposedly more superior platform. But like you say the guys that started the topic already fixed the problem, and I don't want to highjack the topic, just wanted to let them know that they certainly not the only people experiencing that issue. So here is hoping the guys will share what they did to resolve the performance issue. Regards Marius
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
RE: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Hello all again, I have met more computers with Windows 2008 R2 64bit where the performance is very bad. I was importing into database about 80 GB files into tables with blob fields I had to use for server casual Windows 7 32bit computer to get it done on time. How can it be, that Intel i3 with 4GB RAM 32bit is 6 times faster that multi CPU Xeon server. Every core was 100% busy when executing SQL statements. ... I don't believe that I am the only one having these problems. SL This is a known problem with 64 bit versions of all Windows products. SL The problem is that 64bit build want to use up to 1TB of RAM (ie. all available) for file cache purposes. SL You need to look the Dynamic Windows Cache service from Microsoft. Sean
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Hello, AFAIK, the parameter DefaultDbCachePages is intended for newly created databases as default size of cache pages. It doesn't have effect on existing databases where its own setting is used. Every database can have own setting about count of cache pages. The DefaultDbCachePages parameter in firebird.conf applies when page buffers of the database is set to 0. It seems to be still not solving this problem using by FileSystemCacheSize. What else can I test? I haven't followed the entire thread, but first I would rule out I/O problems like faulty RAID controllers etc. In a particular case I was called, although a high-end server in that case, performance was worse than on an oldish laptop. Then there are various tuning/optimizations techniques and settings, which I usually discuss and go through at customer sites. Page size, page buffers, hash slots, increasing RAM usage for the sorting module etc. Once the tuning/configuration side is exhausted, SQL tuning is probably the most important thing. At least from my experience. For sure, I would move away from SuperServer to Classic or SuperClassic to get an overall increase in CPU utilization in a multi-user environment. Although e.g. gbak is still bound to a single core. -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. 22.01.2014 15:05 - Hugo Eyng hugoe...@msn.com Try changing values for DefaultDbCachePages Em 21/01/2014 18:40, Roland Turcan escreveu: I have tried to change this parameter (actually =20), but I don't see any change. My server box is: Hewlett Packard server Intel Xeon CPU E31220 @ 3.10GHx 10GB RAM (8 GB RAM is usable) Firebird 2.5.2 64bit SuperServer single database is being used where its size is about 80GB When I copy any big file to test the performance of disk field then I can see that it can force disk performance, but Firebird is still relaxing. When I try to backup database using gbak no change. CPU core is on 3-6% and disk load is about 1MB/s What can I check else? Thanks in advance. TRoland; 21.01.2014 15:17 - Hugo Eyng hugoe...@msn.com mailto:hugoe...@msn.com I changed the paramter FileSystemCacheSize = 0 to FileSystemCacheSize = 20 in the firebird.conf as suggested in: http://dyemanov.blogspot.com.br/2012/03/firebird-vs-windows-file-system-caching.html Hugo Em 21/01/2014 12:06, Roland Turcan escreveu: Yes, I am interested too. What was the key to get rid of this problem? Thanks in advance. 21.01.2014 15:29 - Fabiano - Desenvolvimento SCI fabi...@sci10.com.br mailto:fabi...@sci10.com.br How you solved your problem? *De: *firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com[mailto:firebird-support@yahoogroups.com] *Em nome de *Hugo Eyng *Enviada em:* terça-feira, 21 de janeiro de 2014 10:24 *Para: *firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com *Assunto:* Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2 Hi Helen. Thanks for your answer. You are right. But the Windows 64 file cache performance was a problem, as said Sean. Só 'reserving' 10GB as a RAM DRIVE grant that I would have always available RAM. But now I solved the 'cache performance' and I will not need RAM DRIVE anymore. Even so, the FB performance is not compatible to the hardware used to run it. Em 20/01/2014 23:12, Helen Borrie escreveu: At 02:01 p.m. 21/01/2014, Hugo Eyng wrote: As Firebird do not use available RAM I created a RAM DRIVE with 10GB and pointed parameter 'TempDirectories' (firebird.conf) to this RAM DRIVE, but FB just uses it rarely in very big 'SELECT'. OK, when FB uses the RAM DRIVE it increases a SELECT speed in more than 80%. I expected FB could use this for every SELECTS and so improve the application. Fb uses RAM directly for sorts, if enough is available. It only takes the sort sets to disk if available RAM is insufficient. Helen Borrie, Support Consultant, IBPhoenix (Pacific) Author of The Firebird Book and The Firebird Book Second Edition http://www.firebird-books.net __ -- Atenciosamente, Hugo Eyng How you solved your problem? *De: *firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com[mailto:firebird-support@yahoogroups.com] *Em nome de *Hugo Eyng *Enviada em:* terça-feira, 21 de janeiro de 2014 10:24 *Para: *firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com *Assunto:* Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2 Hi Helen. Thanks for your answer. You are right. But the Windows 64 file cache performance was a problem, as said Sean. Só 'reserving' 10GB as a RAM DRIVE grant that I would have always available RAM
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Hi! CristalDiskMark: Seq 468 MB/s Read161 MB/s Write(Ten times faster than a notebook vostro 1510 intel core 2 duo 1.8ghz) Sequential Disk performance is completely irrelevant to a database workload which is 99% random I/O. You need to check the random disk performance. Make sure your BBWC / FBWC is in good state and you've chosen a small stripe size on the RAID set where the database resides. hth, Michael ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ 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: http://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
I use SuperClassic and seted the DefaultDbCachePages = 2250 The Default value is 75 Than I used a multiple of 75 The amount of memory used by FB service increases a lot and the performance increases too Em 23/01/2014 02:52, Alexey Kovyazin escreveu: Hi Roland, I have tried to change this parameter (actually =20), but I don't see any change. 20? It is below all meaningful values. If you are using SuperServer, set 1, if Classic or SuperClassic, set 1024, and _restart_ Firebird. What else can I test? If you are interested in professional optimization (http://ib-aid.com/services/optimization), contact our support. Regards, Alexey Kovyazin www.IBSurgeon.com AFAIK, the parameter DefaultDbCachePages is intended for newly created databases as default size of cache pages. It doesn't have effect on existing databases where its own setting is used. Every database can have own setting about count of cache pages. It seems to be still not solving this problem using by FileSystemCacheSize. What else can I test? Thanks. 22.01.2014 15:05 - Hugo Eyng hugoe...@msn.com Try changing values for DefaultDbCachePages Em 21/01/2014 18:40, Roland Turcan escreveu: I have tried to change this parameter (actually =20), but I don't see any change. My server box is: Hewlett Packard server Intel Xeon CPU E31220 @ 3.10GHx 10GB RAM (8 GB RAM is usable) Firebird 2.5.2 64bit SuperServer single database is being used where its size is about 80GB When I copy any big file to test the performance of disk field then I can see that it can force disk performance, but Firebird is still relaxing. When I try to backup database using gbak no change. CPU core is on 3-6% and disk load is about 1MB/s What can I check else? Thanks in advance. TRoland; 21.01.2014 15:17 - Hugo Eyng hugoe...@msn.com mailto:hugoe...@msn.com I changed the paramter FileSystemCacheSize = 0 to FileSystemCacheSize = 20 in the firebird.conf as suggested in: http://dyemanov.blogspot.com.br/2012/03/firebird-vs-windows-file-system-caching.html Hugo Em 21/01/2014 12:06, Roland Turcan escreveu: Yes, I am interested too. What was the key to get rid of this problem? Thanks in advance. 21.01.2014 15:29 - Fabiano - Desenvolvimento SCI fabi...@sci10.com.br mailto:fabi...@sci10.com.br How you solved your problem? *De: *firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com[mailto:firebird-support@yahoogroups.com] *Em nome de *Hugo Eyng *Enviada em:* terça-feira, 21 de janeiro de 2014 10:24 *Para: *firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com *Assunto:* Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2 Hi Helen. Thanks for your answer. You are right. But the Windows 64 file cache performance was a problem, as said Sean. Só 'reserving' 10GB as a RAM DRIVE grant that I would have always available RAM. But now I solved the 'cache performance' and I will not need RAM DRIVE anymore. Even so, the FB performance is not compatible to the hardware used to run it. Em 20/01/2014 23:12, Helen Borrie escreveu: At 02:01 p.m. 21/01/2014, Hugo Eyng wrote: As Firebird do not use available RAM I created a RAM DRIVE with 10GB and pointed parameter 'TempDirectories' (firebird.conf) to this RAM DRIVE, but FB just uses it rarely in very big 'SELECT'. OK, when FB uses the RAM DRIVE it increases a SELECT speed in more than 80%. I expected FB could use this for every SELECTS and so improve the application. Fb uses RAM directly for sorts, if enough is available. It only takes the sort sets to disk if available RAM is insufficient. Helen Borrie, Support Consultant, IBPhoenix (Pacific) Author of The Firebird Book and The Firebird Book Second Edition http://www.firebird-books.net __ -- Atenciosamente, Hugo Eyng How you solved your problem? *De: *firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com[mailto:firebird-support@yahoogroups.com] *Em nome de *Hugo Eyng *Enviada em:* terça-feira, 21 de janeiro de 2014 10:24 *Para: *firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com *Assunto:* Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2 Hi Helen. Thanks for your answer. You are right. But the Windows 64 file cache performance was a problem, as said Sean. Só 'reserving' 10GB as a RAM DRIVE grant that I would have always available RAM. But now I solved the 'cache performance' and I will not need RAM DRIVE anymore. Even so, the FB performance is not compatible to the hardware used to run it. Em 20/01/2014 23:12, Helen Borrie escreveu: At 02:01 p.m. 21/01/2014, Hugo Eyng wrote: As Firebird do not use available RAM I created a RAM DRIVE with 10GB and pointed parameter 'TempDirectories' (firebird.conf) to this RAM DRIVE, but FB just uses it rarely
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Hi Roland, I have tried to change this parameter (actually =20), but I don't see any change. 20? It is below all meaningful values. If you are using SuperServer, set 1, if Classic or SuperClassic, set 1024, and _restart_ Firebird. What else can I test? If you are interested in professional optimization (http://ib-aid.com/services/optimization), contact our support. Regards, Alexey Kovyazin www.IBSurgeon.com AFAIK, the parameter DefaultDbCachePages is intended for newly created databases as default size of cache pages. It doesn't have effect on existing databases where its own setting is used. Every database can have own setting about count of cache pages. It seems to be still not solving this problem using by FileSystemCacheSize. What else can I test? Thanks. 22.01.2014 15:05 - Hugo Eyng hugoe...@msn.com Try changing values for DefaultDbCachePages Em 21/01/2014 18:40, Roland Turcan escreveu: I have tried to change this parameter (actually =20), but I don't see any change. My server box is: Hewlett Packard server Intel Xeon CPU E31220 @ 3.10GHx 10GB RAM (8 GB RAM is usable) Firebird 2.5.2 64bit SuperServer single database is being used where its size is about 80GB When I copy any big file to test the performance of disk field then I can see that it can force disk performance, but Firebird is still relaxing. When I try to backup database using gbak no change. CPU core is on 3-6% and disk load is about 1MB/s What can I check else? Thanks in advance. TRoland; 21.01.2014 15:17 - Hugo Eyng hugoe...@msn.com mailto:hugoe...@msn.com I changed the paramter FileSystemCacheSize = 0 to FileSystemCacheSize = 20 in the firebird.conf as suggested in: http://dyemanov.blogspot.com.br/2012/03/firebird-vs-windows-file-system-caching.html Hugo Em 21/01/2014 12:06, Roland Turcan escreveu: Yes, I am interested too. What was the key to get rid of this problem? Thanks in advance. 21.01.2014 15:29 - Fabiano - Desenvolvimento SCI fabi...@sci10.com.br mailto:fabi...@sci10.com.br How you solved your problem? *De: *firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com[mailto:firebird-support@yahoogroups.com] *Em nome de *Hugo Eyng *Enviada em:* terça-feira, 21 de janeiro de 2014 10:24 *Para: *firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com *Assunto:* Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2 Hi Helen. Thanks for your answer. You are right. But the Windows 64 file cache performance was a problem, as said Sean. Só 'reserving' 10GB as a RAM DRIVE grant that I would have always available RAM. But now I solved the 'cache performance' and I will not need RAM DRIVE anymore. Even so, the FB performance is not compatible to the hardware used to run it. Em 20/01/2014 23:12, Helen Borrie escreveu: At 02:01 p.m. 21/01/2014, Hugo Eyng wrote: As Firebird do not use available RAM I created a RAM DRIVE with 10GB and pointed parameter 'TempDirectories' (firebird.conf) to this RAM DRIVE, but FB just uses it rarely in very big 'SELECT'. OK, when FB uses the RAM DRIVE it increases a SELECT speed in more than 80%. I expected FB could use this for every SELECTS and so improve the application. Fb uses RAM directly for sorts, if enough is available. It only takes the sort sets to disk if available RAM is insufficient. Helen Borrie, Support Consultant, IBPhoenix (Pacific) Author of The Firebird Book and The Firebird Book Second Edition http://www.firebird-books.net __ -- Atenciosamente, Hugo Eyng How you solved your problem? *De: *firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com[mailto:firebird-support@yahoogroups.com] *Em nome de *Hugo Eyng *Enviada em:* terça-feira, 21 de janeiro de 2014 10:24 *Para: *firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com *Assunto:* Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2 Hi Helen. Thanks for your answer. You are right. But the Windows 64 file cache performance was a problem, as said Sean. Só 'reserving' 10GB as a RAM DRIVE grant that I would have always available RAM. But now I solved the 'cache performance' and I will not need RAM DRIVE anymore. Even so, the FB performance is not compatible to the hardware used to run it. Em 20/01/2014 23:12, Helen Borrie escreveu: At 02:01 p.m. 21/01/2014, Hugo Eyng wrote: As Firebird do not use available RAM I created a RAM DRIVE with 10GB and pointed parameter 'TempDirectories' (firebird.conf) to this RAM DRIVE, but FB just uses it rarely in very big 'SELECT'. OK, when FB uses the RAM DRIVE it increases a SELECT speed in more than 80%. I expected FB could use this for every SELECTS and so improve the application. Fb uses RAM directly for sorts, if enough is available. It only takes
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Maybe your problem is that you buy a internet server from dell, not a database server! What is the diference? Internet servers from Dell does not have a disk controller WITH physical cache. Run CrystalDiskMark or other disk benckmark on this computer and in another desktop computer. If it is slow you need to replace your disk controller. Also read from Helen sayd. You are loosing the point when using a gente ram disk. Em 20/01/2014 23:01, Hugo Eyng hugoe...@msn.com escreveu: Hi. I am facing a similar situation. 32GB RAM Dell PowerEdge R420 Intel Xeon CPU E5-2609 two processors 2.40ghz 8 cores RAID Firebird 2.5.2 do not use the available resources of the server even I try to login to the server just one user. I am using SuperClassic I felt a little diference by modifying parameters in firebird.conf like DefaultDbCachePages = 2250 and some others This increases performance in about 30% in my case But I expected more. As Firebird do not use available RAM I created a RAM DRIVE with 10GB and pointed parameter 'TempDirectories' (firebird.conf) to this RAM DRIVE, but FB just uses it rarely in very big 'SELECT'. OK, when FB uses the RAM DRIVE it increases a SELECT speed in more than 80%. I expected FB could use this for every SELECTS and so improve the application. Hugo Eyng Em 20/01/2014 20:51, Roland Turcan escreveu: Hello guys, I found some info about problems with performance when FB is running on Win2008R2 which is domain controller. But in my case is it not DC, but the performance is the worst I met. It is new server running 10GB of RAM, RAID, ... it is quite new server box. It cannot be, that basically dummy update on table with about 700 000 records is executing over one hour. CPU is relaxing, HDD is relaxing too and I cannot force server to fun faster. What can I check? Thanks in advance. -- Best regards, TRoland http://www.rotursoft.sk http://exekutor.rotursoft.sk -- Atenciosamente, Hugo Eyng
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Hi Helen. Thanks for your answer. You are right. But the Windows 64 file cache performance was a problem, as said Sean. Só 'reserving' 10GB as a RAM DRIVE grant that I would have always available RAM. But now I solved the 'cache performance' and I will not need RAM DRIVE anymore. Even so, the FB performance is not compatible to the hardware used to run it. Em 20/01/2014 23:12, Helen Borrie escreveu: At 02:01 p.m. 21/01/2014, Hugo Eyng wrote: As Firebird do not use available RAM I created a RAM DRIVE with 10GB and pointed parameter 'TempDirectories' (firebird.conf) to this RAM DRIVE, but FB just uses it rarely in very big 'SELECT'. OK, when FB uses the RAM DRIVE it increases a SELECT speed in more than 80%. I expected FB could use this for every SELECTS and so improve the application. Fb uses RAM directly for sorts, if enough is available. It only takes the sort sets to disk if available RAM is insufficient. Helen Borrie, Support Consultant, IBPhoenix (Pacific) Author of The Firebird Book and The Firebird Book Second Edition http://www.firebird-books.net __ -- Atenciosamente, Hugo Eyng
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Hi Fabiano. My server: * Intel® Xeon® E5-2609 v2 2.50GHz,10M Cache, 6.4GT/s QPI, No Turbo, 4C, 80W, Max Mem 1333MHz * 8GB RDIMM, 1600MT/s, Low Volt, Dual Rank, x4 Data Width * HD 6 x 300GB SAS, 10K RPM, 6GBPS Hot-Plug de 2.5 * PowerEdgeR620,Intel®Xeon®E-26XXv2Processors CristalDiskMark: Seq 468 MB/s Read161 MB/s Write(Ten times faster than a notebook vostro 1510 intel core 2 duo 1.8ghz) Em 21/01/2014 07:52, fabianoas...@gmail.com escreveu: Maybe your problem is that you buy a internet server from dell, not a database server! What is the diference? Internet servers from Dell does not have a disk controller WITH physical cache. Run CrystalDiskMark or other disk benckmark on this computer and in another desktop computer. If it is slow you need to replace your disk controller. Also read from Helen sayd. You are loosing the point when using a gente ram disk. Em 20/01/2014 23:01, Hugo Eyng hugoe...@msn.com mailto:hugoe...@msn.com escreveu: Hi. I am facing a similar situation. 32GB RAM Dell PowerEdge R420 Intel Xeon CPU E5-2609 two processors 2.40ghz 8 cores RAID Firebird 2.5.2 do not use the available resources of the server even I try to login to the server just one user. I am using SuperClassic I felt a little diference by modifying parameters in firebird.conf like DefaultDbCachePages = 2250 and some others This increases performance in about 30% in my case But I expected more. As Firebird do not use available RAM I created a RAM DRIVE with 10GB and pointed parameter 'TempDirectories' (firebird.conf) to this RAM DRIVE, but FB just uses it rarely in very big 'SELECT'. OK, when FB uses the RAM DRIVE it increases a SELECT speed in more than 80%. I expected FB could use this for every SELECTS and so improve the application. Hugo Eyng Em 20/01/2014 20:51, Roland Turcan escreveu: Hello guys, I found some info about problems with performance when FB is running on Win2008R2 which is domain controller. But in my case is it not DC, but the performance is the worst I met. It is new server running 10GB of RAM, RAID, ... it is quite new server box. It cannot be, that basically dummy update on table with about 700 000 records is executing over one hour. CPU is relaxing, HDD is relaxing too and I cannot force server to fun faster. What can I check? Thanks in advance. -- Best regards, TRoland http://www.rotursoft.sk http://exekutor.rotursoft.sk -- Atenciosamente, Hugo Eyng -- Atenciosamente, Hugo Eyng
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Hi Fabiano. The numbers of CristalDiskMarkSx64 are better: 662 MB/s read and 169 MB/s write I don´t know de difference between CristalDiskMarkX64 and DiskMarkSx64 But DiskMarkSx64 gave me better numbers. Hugo Em 21/01/2014 07:52, fabianoas...@gmail.com escreveu: Maybe your problem is that you buy a internet server from dell, not a database server! What is the diference? Internet servers from Dell does not have a disk controller WITH physical cache. Run CrystalDiskMark or other disk benckmark on this computer and in another desktop computer. If it is slow you need to replace your disk controller. Also read from Helen sayd. You are loosing the point when using a gente ram disk. Em 20/01/2014 23:01, Hugo Eyng hugoe...@msn.com mailto:hugoe...@msn.com escreveu: Hi. I am facing a similar situation. 32GB RAM Dell PowerEdge R420 Intel Xeon CPU E5-2609 two processors 2.40ghz 8 cores RAID Firebird 2.5.2 do not use the available resources of the server even I try to login to the server just one user. I am using SuperClassic I felt a little diference by modifying parameters in firebird.conf like DefaultDbCachePages = 2250 and some others This increases performance in about 30% in my case But I expected more. As Firebird do not use available RAM I created a RAM DRIVE with 10GB and pointed parameter 'TempDirectories' (firebird.conf) to this RAM DRIVE, but FB just uses it rarely in very big 'SELECT'. OK, when FB uses the RAM DRIVE it increases a SELECT speed in more than 80%. I expected FB could use this for every SELECTS and so improve the application. Hugo Eyng Em 20/01/2014 20:51, Roland Turcan escreveu: Hello guys, I found some info about problems with performance when FB is running on Win2008R2 which is domain controller. But in my case is it not DC, but the performance is the worst I met. It is new server running 10GB of RAM, RAID, ... it is quite new server box. It cannot be, that basically dummy update on table with about 700 000 records is executing over one hour. CPU is relaxing, HDD is relaxing too and I cannot force server to fun faster. What can I check? Thanks in advance. -- Best regards, TRoland http://www.rotursoft.sk http://exekutor.rotursoft.sk -- Atenciosamente, Hugo Eyng -- Atenciosamente, Hugo Eyng
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Check for long running transactions. Test: disconnect everithing from database and run a gfix -sweep. If you solved your problem you have long running transactions Em 20/01/2014 20:51, Roland Turcan k...@rotursoft.sk escreveu: Hello guys, I found some info about problems with performance when FB is running on Win2008R2 which is domain controller. But in my case is it not DC, but the performance is the worst I met. It is new server running 10GB of RAM, RAID, ... it is quite new server box. It cannot be, that basically dummy update on table with about 700 000 records is executing over one hour. CPU is relaxing, HDD is relaxing too and I cannot force server to fun faster. What can I check? Thanks in advance. -- Best regards, TRoland http://www.rotursoft.sk http://exekutor.rotursoft.sk
RE: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
I found some info about problems with performance when FB is running on Win2008R2 which is domain controller. But in my case is it not DC, but the performance is the worst I met. It is new server running 10GB of RAM, RAID, ... it is quite new server box. It cannot be, that basically dummy update on table with about 700 000 records is executing over one hour. CPU is relaxing, HDD is relaxing too and I cannot force server to fun faster. What is the database file size? Is the DB file larger than RAM? If so, there are known issues with Window file cache performance under x64 mode. Check list archives for previous posts or google Windows 64 file cache performance. Sean
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Hi. I am facing a similar situation. 32GB RAM Dell PowerEdge R420 Intel Xeon CPU E5-2609 two processors 2.40ghz 8 cores RAID Firebird 2.5.2 do not use the available resources of the server even I try to login to the server just one user. I am using SuperClassic I felt a little diference by modifying parameters in firebird.conf like DefaultDbCachePages = 2250 and some others This increases performance in about 30% in my case But I expected more. As Firebird do not use available RAM I created a RAM DRIVE with 10GB and pointed parameter 'TempDirectories' (firebird.conf) to this RAM DRIVE, but FB just uses it rarely in very big 'SELECT'. OK, when FB uses the RAM DRIVE it increases a SELECT speed in more than 80%. I expected FB could use this for every SELECTS and so improve the application. Hugo Eyng Em 20/01/2014 20:51, Roland Turcan escreveu: Hello guys, I found some info about problems with performance when FB is running on Win2008R2 which is domain controller. But in my case is it not DC, but the performance is the worst I met. It is new server running 10GB of RAM, RAID, ... it is quite new server box. It cannot be, that basically dummy update on table with about 700 000 records is executing over one hour. CPU is relaxing, HDD is relaxing too and I cannot force server to fun faster. What can I check? Thanks in advance. -- Best regards, TRoland http://www.rotursoft.sk http://exekutor.rotursoft.sk -- Atenciosamente, Hugo Eyng
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
At 02:01 p.m. 21/01/2014, Hugo Eyng wrote: As Firebird do not use available RAM I created a RAM DRIVE with 10GB and pointed parameter 'TempDirectories' (firebird.conf) to this RAM DRIVE, but FB just uses it rarely in very big 'SELECT'. OK, when FB uses the RAM DRIVE it increases a SELECT speed in more than 80%. I expected FB could use this for every SELECTS and so improve the application. Fb uses RAM directly for sorts, if enough is available. It only takes the sort sets to disk if available RAM is insufficient. Helen Borrie, Support Consultant, IBPhoenix (Pacific) Author of The Firebird Book and The Firebird Book Second Edition http://www.firebird-books.net __
Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2
Guten Tag Roland Turcan, a large Raid Stripe Set can be a real showstopper for Databases what are your settings for Database Page Size and for the Raid What Type of Raid 1,5,10 Size of the Stripe Set Hello guys, I found some info about problems with performance when FB is running on Win2008R2 which is domain controller. But in my case is it not DC, but the performance is the worst I met. It is new server running 10GB of RAM, RAID, ... it is quite new server box. It cannot be, that basically dummy update on table with about 700 000 records is executing over one hour. CPU is relaxing, HDD is relaxing too and I cannot force server to fun faster. What can I check? Thanks in advance. -- Mit freundlichen Grüssen Hannes Streichermailto:hstreic...@gmx.de ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ 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: http://info.yahoo.com/legal/us/yahoo/utos/terms/