One possible explanation is that changes to the FB database are being scanned by an antivirus program, and that the SQL Server database has been explicitly excluded from the scan.

The other possible explanation is to do with the type of RAID controller card. I believe some cards are unable to efficiently handle page writes above a certain size (or something like that). A client of ours had this problem, and it was solved in this way by their server-supplier changing the card. Sorry to be so vague.


Roger Vellacott.

--- In firebird-support@yahoogroups.com, Maarten Klerk <mklerk@...> wrote:
>
> Hi all,
>
> Does anyone have a suggestion to solve the following problem?
>
> We are running Windows Server 2008 R2 on a brand new Dell PowerEdge
> with 4 cores and a RAID contoller system, with 2 harddisks.
>
> On top of it we run an application server and a firebird server (2.1,
> superserver).
>
> In this configuration Firebird seems to be very slow. It really slows
> down our whole application. It seems to be caused by the combination
> of firebird and a RAID controller. (I googled it). I would like to
> prove that this is the problem in our case as well.
> Maarten Klerk
>