Is there a way to find VS response time from VSE, either from any log file or database table (in both Performance or Norma mode)

[Tarun_28]

Is there a way to find VS response time from VSE, either from any log file or database table (in both Performance or Normal mode)

 

Thanks

Tarun

[Shiney Abraham]

We capture Virtual Service Response Time and generate reports. This report is useful for determining how different system loads or performance testing impacts the response times for a virtual service. Please see documentations for the same.  

Virtual Service Metrics Reports - DevTest Solutions - 10.3 - CA Technologies Documentation 

[Tarun_28]

Thanks Shiney for response. Reports are fine, I am looking for raw data.

Where do VSE logs response time of VS response. Do I need to enable any config to log it either in log or database.

 

This is required to design a monitoring solution which will reside over multiple VSE's. 

[Maria Heloisa De Oliveira Santos Flores]

Tarun,

 

The metrics that generate the reports are all stored in the database configured with the Registry.

The VSE collects the details in memory and then write out the details to the database every 5 minutes.
The VSE DB tables are:
VSE_METRICS_EVENTS
VSE_METRICS_PERIODICS
VSE_METRICS_TXN_COUNTS

 

The following properties are used to control the metrics collection in LISA Virtual Services Environment servers. The values here are the defaults.

 

lisa.vse.metrics.collect=true
Main property to turn on the overall metrics collection (true) or off (false):

 

lisa.vse.metrics.sample.interval=5m
This property controls how often transaction rate and response times are sampled.

 

lisa.vse.metrics.delete.cycle=1h
lisa.vse.metrics.delete.age=30d
These properties control how often old metric data is scanned for and deleted, and what is considered old.

 

It should be fine to read the data from the database, but any direct writes to the database will place the installation using that database out of support.

 

Hope it helps.

Heloisa

[Tarun_28]

Thanks Maria for your time. Information given is very helpful.

Though I am looking for place where response time metrics are logged for each transaction thread wise, if there is a possibility.

Given information solves lot of problem.

 

Thanks again!

[Shiney Abraham]

Tarun,  look in the VS_XXXX.log (where XXXX refers to the virtual service name). you will see information including the operation and the arguments that DevTest parsed when the request hit the VS and the time. 

Or 

You could write a query to get that info from the VSE tables in the database..  Use the VSE_METRICS_EVENTS  Table to capture this information.  

 

Thanks

 

Shiney.