Subject Re: Windows Server 2003 vs Linux
Author paul.mercea

the best performance i get from Win 2008 x64 server core installation (without gui).


--- In, "Anderson Farias" <peixedragao@...> wrote:
> Hi all,
> Most of my experience with FB have been on Linux servers. Now, I need to
> check on a FB 1.5 Classic server running on a Windows Server 2003 (SMP) box
> for performance and stability issues.
> This is an FB DB dedicated server, that deals with about 300+ concurrent
> connections (and going to 400+ soon). One of my first thoughts were to get
> Windows Server out and install Linux since I have the 'feeling' this would
> be a first step on getting more from the machine.
> But, before I do that, I'd like to hear from your experience (on using
> Windows Server as FB DB server and, even better, from those who have
> comparisions between Windows and Linux for this matter)
> So, is changing from Windows Server to Linux (RHEL 5.0 for instance) an
> important step *or* I'll probably see no difference at all?
> If it's important, the machine is a Dell system with 2x 4-core Xeon
> processors, 4Gb of RAM and SAS disks. The DB is about 3Gb only, 8k page size
> and 75 cache pages.
> One of the big problems is that some of the C/S apps that use this DB do not
> handle transactions well and db gets stuck with many record versions...
> than, also there are a lot of bad indices (hi MaxDup, like 80% of table
> records) than when garbage collect get to run, the server gets too busy and
> kind stop handling new connections (People are already working on get rid of
> these bad indexes)
> Thanks for any info,
> Regards,
> Anderson Farias