Not able to see the performance metrics for all the services in the portal, how to validate that in Database

Products

• CA Application Test
• Service Virtualization

Issue/Introduction

Not able to see the performance metrics - virtual service response time for all the services that are up and running.

 

How to query the database if the metrics are being captured or not? 

Environment

All supported DevTest releases.

Cause

N/A

Resolution

Here is a sample query you can run against your Registry database:  

select * from VSE_METRICS_PERIODICS where METRIC_NAME='Response Time' and vse_name='ssl://74N9GH2:2013/VSE' and vs_name='talent' and PERIOD_TS>'2020-04-01' and PERIOD_TS<'2020-04-15'

Change VSE name and  VS  name (name of the virtual service)  and time period to match yours.