Subject RE: [firebird-support] Firebird performance issues on VM platform
Author Leyne, Sean
Ken,

> > --was the database file-copied onto the colocation server, or gbak-
> restored? (Could be lots of garbage there if it was file copied.)
>
> Yes, the DBs were simply copied. Interestingly, upon attempting to
> backup/restore a few ~300mb DBs, the operation takes around 8 minutes.
> The same operation on a slightly larger DB on my local PC takes 2 minutes.

This points to a problem with the HDD controller/storage sub-system which the server is using!

Have you run disk performance/benchmark tools on the system to see what the performance of the server? Then compared that to the performance that the VM is getting? Then compared that to a separate/local computer?

I am very confident that you will find a huge performance problem with the server.


Sean


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.