I have a relatively small database (6GB) and my application can access it quickly when using Firebird 2.1 or Firebird 2.5 on a non-server version of windows. But if I try to use Firebird 2.5 on a server version (2008, 2012) it gets painfully slow.
What I've tried already:
- Set FileSystemCacheSize on firebird.conf to 50, 60 and 70% as noted here
Notes:
- The problem happens on more than one machine
- Unfortunately the problem is still not deterministic as we have tested with Win Server 2008 and 2012 on a simple desktop machine and the performance was very good but on some server hardware it ts slow.
- Untill now the issue showed up only on Dell Servers
Hardware that shows the issue:
- Dell Perc H310 SCSI
Hardware that don't show the issue
- Dell Desktop Vostro
My question is, what should I look for to find out what is causing this performance issue?