Not able to see the performance metrics for all the services in the portal, how to validate that in Database
book
Article ID: 190268
calendar_today
Updated On:
Products
CA Application TestService 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.