Subject Re: Firebird performance issues on VM platform
Author Myles Wakeham
Sean writes:

>P.S. We have 3 MS HyperV servers and 2 VMWare servers in our office --
HDD performance can be a real problem when dealing with VM environments.

This is very interesting. I'm dealing with a system that was running on
a dedicated box, that we migrated to a VM about 12 months ago. The
users are telling me that the very same application that was running
acceptably fast before, is now slow. From what I can tell, its on
relatively complex SELECT queries against a pretty large database, and
it suggests the same issues that others are talking about in regards to
hard disk performance.

I'm inclined to leave the application on the VM (its a PHP app) and move
the database to a dedicated box, not on a VM, to see if this would help
however if there are settings that can increase VM performance for hard
disk access, I'm all ears. This is on VMWare ESXi 3.5 with a CentOS 5.3
32 bit OS for both the app and Firebird on the same virtual server. Do
you have any suggestions for any tools to check performance that can be
used in these environments?

Myles
--
-----------------------------
Myles Wakeham
Director of Engineering
Tech Solutions USA, Inc.
www.techsolusa.com
Phone +1-480-451-7440