Subject Re: [ib-support] Database won't close.
Author Don Gollahon
Please note: I'm sending this in a variety of ways because not all messages
are reaching the newsgroup. (very frustrating).

> When the database is not shutting down, you said it's
> using about half the CPU. How much memory is it using
> and does that amount change.

On the test workstation the memory usage stays steady at 117,800K out of
331,800K. I'll have to have him check next time to see what portion of that
is Firebird's. CPU usage stays fairly level between 48% and 52%.

Amount of this that is IBServer.exe: 31,200K to 39,000K stays within this
range.


> How much I/O is it doing?

I/O Read bytes: 7,085,985,049 and climbing while stuck.
I/O Write bytes: 2,045,508,000 and climbing while stuck.


> Can you reconnect? Does that take a long time?

Once it is stalled you can't login to Firebird on that machine. He ends up
shutting down Firebird. No problems reconnecting after that.


> Does this happen every time or just sometimes?

This happens all the time for this process. It happens to all databases
we've tested it with that are greater than about 600 MB. Smaller ones run
fine.


> Does it matter whether the database has been restored recently?

Today we did a backup and restore. Then reran the app. Same results.




""Ann W. Harrison"" <aharrison@...> wrote in message
news:<5.1.0.14.2.20021112170442.02326f10@...>...
> When the database is not shutting down, you said it's
> using about half the CPU. How much memory is it using
> and does that amount change. How much I/O is it doing?
> Can you reconnect? Does that take a long time? Does
> this happen every time or just sometimes? Does it matter
> whether the database has been restored recently?
>
>
> Regards,
>
> Ann
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>