I am trying to get some information from VSE_METRIC_PERIODICS table to genarate some useful report out of it But not clear about below things. Kindly provide details how this works. All Vse metric properties in Lisa.properties file are kept as default.
Version used: 8.0
Databse : Derby
- Is metric value for response time in millisecond and is this averaged for all the trnsactions recived
- By default VSE logs in table every 5 minutes . So is it like it only logs trnsaction count recived at that particular time or sum of all the trnsactions recived within that 5 minutes .
- I want to get the transactions at particular second with response time and genrate something useful.