How to do it...

Follow the steps in this recipe to calculate the average execution time for multi-tier web requests:

  1. Log in to your Splunk server.
  2. Select the Operational Intelligence application.
  3. Ensure the time range picker is set to Last 24 Hours, and type the following search into the Splunk search bar. Then, click on the search button or hit Enter:
index=main sourcetype=access_combined | join JSESSIONID  usetime=true earlier=false [ search index=main  sourcetype=log4j | transaction threadId maxspan=5m | eval  JSESSIONID=sessionId ] | stats avg(duration) AS  Avg_Request_Execution_Time 
  1. After a little while, Splunk will return a single value representing the average execution time in seconds for a complete web request on the website. ...

Get Splunk Operational Intelligence Cookbook - Third Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.