Interbase database running slow
Posted on 2008-06-11
I have a client that runs a 4 gig database on interbase 7.5. It runs slow. I am not the support for the application but support the server and network. I have suggested they should have a seperate interbase server for the application. They have about 25 users. They are running it on a single HP ML330 G3 server with two processors(about 3gig) 3gig ram two raid 1 arrays. The server is about 4-5 years old. The OS is SBS 2003 so they run Exchange on the same box. They also have a SQL Express database plus all the user docs and printing. The app provider are saying the server should be ok to run their app and there must be something else wrong. They are suggesting there is something wrong with the network at the moment. What I am looking for is an informed oppinion from a suitably qualified person that can point to any recommended standard or best practice to say that this approach is either right or wrong. I have another client running interbase and their app provider recommends a seperate server and doesnt support it on SBS as it doesnt run well with Exchange. I suspect this is an Interbase recomendation but cant find any reference to it. Also should they be running an interbase backup/restore on a regular basis.