db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Oystein.Grov...@Sun.COM (Øystein Grøvlen)
Subject Re: I need some advice to choose database for an upcomming job
Date Tue, 01 Nov 2005 11:20:49 GMT
>>>>> "BP" == Bryan Pendleton <bpendleton@amberpoint.com> writes:

    >> A "Guidelines"  section starts on  slide 19. Slide 24  lists 100-500
    >> updates per second  -- but, of course, your  actual performance will
    >> depend on the complexity of your transactions.

    BP> Is there a simple way that I can observe what actual performance
    BP> I'm getting? That is, does Derby keep its own monitoring statistics
    BP> about the activity that is occuring, and, if so, how do I retrieve
    BP> those statistics and view them?

    BP> I see that there is SYSCS_GET_RUNTIME_STATISTICS, but that seems
    BP> to be mostly about execution of a single query; how do I see
    BP> information like:
    BP>   - transactions per second
    BP>   - IOs per second (read and write)
    BP>   - active users
    BP>   - memory usage
    BP> etc.

I agree that this would be very useful.


View raw message