G
George Potemkin
Guest
Thanks Andriy! A bit off-topic or the topic: "what you get from VSTs is not what you should report". _IndexStat: _IndexStat-split/_IndexStat-blockdelete supposed to return the number of blocks added to and deleted from an index tree. This information is useful if you are monitoring the fast growing indexes or the indexes that need a close "attention" of idxcompact utility. Unfortunately there is a bug that was fixed only in 11.6: PSC00334196: Incorrect values reported by _IndexStat-split/_IndexStat-blockdelete Before Progress 11.6 the IndexStat-blockdelete is always 0 and _IndexStat-split returns the sum of splits and deletes. But you can use a workaround (or estimation): if _IndexStat-blockdelete eq 0 then assign BlockDelete = _IndexStat-split * _IndexStat-delete / (_IndexStat-delete + _IndexStat-create). BlockSplit = _IndexStat-split - _IndexStat-blockdelete. _ActSummary: _Summary-Commits/_Summary-Undos They return the sum of the allocated as well as active transactions that were committed or undone. The allocated transactions create only minor activity in database and that is why they can be ignored. When you report bi activity per transaction or the table's creates/deletes/updates per transaction you should take into account only active transactions. Percent of the allocated transactions highly depends from an application and may vary from 20% to 80% of all transactions. Each allocated transaction creates 3 TXT latch locks. Each active transaction creates 4 TXT latch locks. Sometimes (but under very specific conditions) it can create 5 TXT latch locks. If we will ignore the last case then the number of allocated transactions can be estimated as: max(0, 4 * _Summary-Commits - _Latch-Lock) for _Latch were _Latch-Id eq 9 or _Latch-Name eq "MTL_TXT". The number of active transactions is _Summary-Commits minus the number of allocated transactions. It should be equal, for example, to the number of transactions reported by rfutil -C aimage scan. Also you can report the number of the unused TRIDs. As you know Progress allocated the bunch of 128 TRIDs at once that can be used (or not being used) by any session. The number of unused TRIDs is an increase of _MstrBlk-lasttask minus _Summary-Commits. Regards, George
Continue reading...
Continue reading...