Subject Firebird performance issues on VM platform
Author Mike Kenyon
Hi Firebird support



I am contacting you in desperation hoping you could please try to assist us.
I am not the developer, but I have cc'd my developer, who could answer any
technical questions if required.



We recently moved/migrated our hosted server (physical server) to a VM
platform - we are now running Windows Server 2008 R2 64 bit OS. We have
found the performance of Firebird to be lacking on this OS / VM platform.
We have tried increasing the physical resources, but this does not help. We
have run IO tests on disk access speed, which resulted in only 3 Gb/sec
access speed. The supplier who hosts this VM server has no idea what to do
to fix the access speed.



We are currently using:

. Firebird 2.1.3 18185 - 64 bit (super server) - have also tried
classic server, but shows no difference in performance

. OS - Windows Server 2008 R2 - 64 bit

. Our applications are mostly developed in Delphi - on this server
we host a web based data warehouse for POS transactions (replication
process), as well as a centralized database management for restaurant groups



The opportunity:

. Slow response time for processing of display of web page data
warehouse, once we run another application that utilizes firebird, our
customers cannot access anything. Firebird does not seem to be overworked
when we look at the cpu/mem usage though? Runs at about 50% cpu max.



What we had before that worked:

. Physical hosted server, quad core, 8Gb RAM, Windows Server 2008 R1





Are there any tweaks or configuration settings/differences in Windows server
2008 R2 we need to make using the new OS with Firebird?



I hope I have provided enough info, if not my developer will have to step in
to answer these - Many thanks!





Regards



Mike Kenyon

_____




cid:image001.jpg@01C8FE28.9D602550






Mobile:

+27 83 411 5950










Office:

+27 11 794 8720



Fax:

+27 86 299 0581



E-mail:

<mailto:mike@...> mike@...






Web:

<http://www.pos-control.co.za/> www.pos-control.co.za
























--
This message has been scanned for viruses and
dangerous content by Pinpoint, and is
believed to be clean.



[Non-text portions of this message have been removed]