Subject Re: [firebird-support] Stability problems
Author Daniel Rail
Hi,

At June 25, 2004, 04:36, Santiago Cordoba wrote:

> <I'm sure that You can give more information :
> <- is System Restore so-called feature is off

> Yes, before restore i execute shutdown

Don't worry, Windows 2000 doesn't have the system restore feature,
only Windows XP.

> < what is the extension of database file (fdb or gdb or else)

> the extension is gdb

This shouldn't affect performance on Win2000.

> <- when exactly server start revoking connections (WAN user connects ?
> <maybe exact query/procedure is
> <executed)

> I do not know it. (It is possible to be loged the SQL request in the
> server?)

> <- log of Firebird server
> The server nothing writes when it passes this.

Do you have Forced Writes ON or OFF?
What is the header statistics of the database? The database header
"might" give some indication as to what is happening.
You can use the GSTAT command-line to retrieve both information.

Do you have an anti-virus running, that might be scanning the file? It
might be the scheduled scan, not the real-time scan.
Do you have a disk defragmenter that might be running at the
time(might be scheduled or running automatically at different times)?

And, is it possible that the WAN users using FR might cause some
problems(maybe the FR connection is not strong enough, sometimes)?

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)