Hi all. We are using Lisa 7.5.1 to deploy and run a number of services over six VSE. In order to improve and speedup the performance statistics, we are running SQL queries right from the Data Base, specifically we use the vse_metrics_periodics table for getting the Tps and response time stats, while the vse_metrics_txn_counts for the transactions counts stats.
We have realized the vse_metrics_txn_counts table have a COUNTS_DATE field over which we must filter the queries. For example we expect the following query shows the total number of transactions processed at the time the query since the beginning of the current day:
group by vs_name
order by vs_name
However even before the day tests are started, it seems the table shows records with the current date but high values on the COUNTS_DATE. It seems it keep the historical accumulated value instead the day’s counts.
This is the vse_metrics_txn_counts layout:
We would like to have a technical description of every field and also the update logics between the table and the VSE.