Re: Transaction Throughput Analysis

The problem with onstat -p commit and rollback count, is that it only counts begin commit/rollback blocks and not standalone statements that don't use a transaction. The numbers are therefore the wrong ones to be compared against other DBMS's Art S. Kagel wrote: > darren@systeam.co.uk wrote: > > > > I'm currently investigating an online 5 database and I require statistics on > > performance on the database engine. I'm particually interested into how to > > measure the number of transactions that are being processed over a pre- > > defined period. > > The best you can do in 5.xx is to run onstat -p and monitor the number > of commits and rollbacks over time. > > Art S. Kagel