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:
select
VS_NAME,
sum(TOTAL_COUNT)
from
vse_metrics_txn_counts
where
COUNTS_DATE=TO_DATE(CURRENT_DATE,'dd/mm/yy')
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:
COLUMN_NAME | DATA_TYPE |
TXN_COUNTS_ID | NUMBER(19,0) |
VSE_NAME | VARCHAR2(100 BYTE) |
VS_NAME | VARCHAR2(100 BYTE) |
COUNTS_DATE | DATE |
MISSES | NUMBER(19,0) |
REQUEST | VARCHAR2(4000 BYTE) |
SPECIFIC_HITS | NUMBER(19,0) |
TOTAL_COUNT | NUMBER(19,0) |
NODE_HITS | NUMBER(19,0) |
We would like to have a technical description of every field and also the update logics between the table and the VSE.
Thanks