Subject Re[2]: [firebird-support] Firebird Hang
Author Andi Wangsadijaya
Halo Helen,

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:
>> KEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
>> 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.

Best regards,
Andi Wangsadijaya

Send instant messages to your online friends