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)
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.
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.
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
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.
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.
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.
Retrieving data ...