Subject Re: [firebird-support] Re: FB2.5SC is slow for 25-35 users
Author Menetrier Gregory
Honestly, i don't know, but it surely consumes resources (network
bandwidth and ???).

From your logs :
> Database: D:\DATASQL\DATA\DATA.FDB
> Allocated 5669 page buffers of 8192 requested
> TS2003 Tue Oct 26 08:37:42 2010
> unable to allocate memory from operating system
here, it's clear, not enough resources.
> TS2003 Tue Oct 26 08:39:07 2010
> Operating system call CloseHandle failed. Error code 6
> TS2003 Tue Oct 26 08:41:00 2010
> Database: D:\DATASQL\DATA\DATA.FDB
> internal Firebird consistency check (wrong record length (183), file:
> vio.cpp line: 1139)
Here, you need a gfix/backup/restore. Might be due to the previous error.

Now I would suggest you to switch back to SuperServer (i read somewhere
this is the recommended setting for Windows) to keep a clean production
service. This will give you time to tweak Windows (if it's possible).

Greg


Le 26/10/2010 15:32, tomkrej a écrit :
>
> Server is used for terminal connections from remote offices - there
> are 3-4 connections.
>
> Is it possibly the reason of slowdown of server???
>
> Tom
> --- In firebird-support@yahoogroups.com
> <mailto:firebird-support%40yahoogroups.com>, Menetrier Gregory
> <gregory.menetrier@...> wrote:
> >
> > There is not only RAM limits, but also system resources available. How
> > many file handles, threads etc. can a Windows Server create/use ?
> > I know that under Linux, these limits exists and you need to tweak the
> > kernel ("too many open files" before using only a 10% of the
> available RAM).
> > I've never tested FB2.5SC under Windows, but we did encounter the same
> > kind of problem using classic server under windows and switched to
> Linux
> > (also for other reasons).
> >
> > Greg
> >
>
>


[Non-text portions of this message have been removed]