Does anyone know if Firebird will work OK (or fantastically) on a
dual Xeon processor machine?

I have heard rumors it won't however would like to confirm it is not
a hang over from the Interbase days...