AnsweredAssumed Answered

Lisa 7.5.1 - Quering VS data from vse_metrics_txn_counts table.

Question asked by OctavioGalindo951214 on Jan 5, 2015
Latest reply on Jan 13, 2015 by chazh01

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

 

 

Outcomes