|Subject||Re: [firebird-support] Firebird Hang|
On Friday, September 29, 2006, 5:06:38 AM, You wrote:
> At 12:48 AM 25/09/2006, you wrote:
> Why do you uninstall it? Why not just stop and restart the Guardian service?
I didn't know with this way. So, i just call uninstall and
install_super of the batch file.
>> I've tried to add the following key:
>> with the key: TcpNumConnections=1000
>> but still get the same error.
> If the server crashing is caused by overwhelming the resources of the
> host machine, this is likely to make it worse, not better.
So, do you mean it's better to remove this key?
> In another posting you eliminated a bad UDF as the cause.
Yes, because the database doesn't use any 3rd UDF. Do I have to check
the standard UDF?
> Tell us something about the memory resources on the host machine and
> about the number of concurrent users logged in when the crashes occur.
The server run with 2 GB of RAM with the number of concurrent users logged
are about 12-14 computers.
> Have you done any monitoring of transaction statistics, using gstat -h?
No, i haven't. I'll try this way later.
> What kind of housekeeping regime do you have? (gbak backups, sweeps?)
I run gbak backups every 1 hours. Is this have an effect?
> What page size are you working with? and what is page buffer size?
I'll reports this to you soon about this, i don't remeber about this.
Send instant messages to your online friends http://asia.messenger.yahoo.com