Subject | Re: [firebird-support] Re: FB2.5SC is slow for 25-35 users |
---|---|
Author | Menetrier Gregory |
Post date | 2010-10-26T15:32:13Z |
Honestly, i don't know, but it surely consumes resources (network
bandwidth and ???).
From your logs :
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 :
bandwidth and ???).
From your logs :
> Database: D:\DATASQL\DATA\DATA.FDBhere, it's clear, not enough resources.
> Allocated 5669 page buffers of 8192 requested
> TS2003 Tue Oct 26 08:37:42 2010
> unable to allocate memory from operating system
> TS2003 Tue Oct 26 08:39:07 2010Here, you need a gfix/backup/restore. Might be due to the previous error.
> 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)
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 :
>[Non-text portions of this message have been removed]
> 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
> >
>
>