Web DDR Reports

Web DDR Reports are used to analyze the root cause of an issue, such as high level response time. User can see ND data from Drill-Down reports and can find out which method is taking more time to execute. User can see Drill down report in online as well as in offline mode.

To open the drill down reports, go to Sessions menu icon on the ND home page (in case of continuous monitoring). The session window is displayed. If sessions are not displayed there, click Show All button. User can apply filters also to search for a particular session.

 note In case of ND mode (non-continuous monitoring), user can view the drill down reports from the test run window in the same manner.

Select the check box corresponding to a particular session and click the down-arrow icon adjacent to the Reports button, and click the Web DDR option.

The system Queries window is displayed.

There are following Drill Down queries:

  • URL
  • Session
  • Transaction
  • DB Requests
  • Exception
  • Method Timing
  • FlowPath
  • Page

The snapshot with detailed description of each report is provided in the subsequent sections:

URL

This report displays URL summary, such as URL name, number of tries, number of success, number of failures, minimum duration, average duration, maximum duration, median, 80th percentile, 90th percentile, 95th percentile, 99th percentile, percentage fail, and script count.

Further Reports in this Section

The user can view further reports from this window by clicking the specified links.

  • To view URL instance report for tried attempts, click the Tried link
  • To view URL instance report for successful attempts, click the Success link
  • To view URL instance report for failed attempts, click the Fail link
  • To view URL Component details, click the Average link
  • To view URL Session Summary, click the Script Count link

Session

This report displays Session summary, such as Script name, number of tries, number of success, number of failures, minimum duration, average duration, maximum duration, median, 80th percentile, 90th percentile, 95th percentile, 99th percentile, and fail percentage.

Further Reports in this Section

The user can view further reports from this window by clicking the specified links.

  • To view the script file in script manager, click the Script Name link
  • To view Session instance report for tried attempts, click the Tried link
  • To view Session instance report for successful attempts, click the Success link
  • To view Session instance report for failed attempts, click the Fail link
  • To view Session details report, click the Average link

Transaction

This report displays Transaction summary, such as transaction name, minimum duration, average duration, maximum duration, median duration, 8th percentile, 90th percentile, 95th percentile, 99th percentile, script count, number of tries, success, fails attempts, and fail percentage.

Further Reports in this Section

The user can view further reports from this window by clicking the specified links.

  • To view Transaction details report, click the Average link
  • To view the Transaction session summary, click the Script Count link
  • To view the transaction instance for successful transactions, click the Tried link
  • To view the transaction instance for failed transactions, click the Fail link

DB Requests

This report provides details on the database query. To view the database query results, click the DB Requests link on the Drill-Down Queries page or click the DB Call Count link on the Flowpath window (for particular flowpath instance). The Database query report is displayed.

This report displays details, such as DB query, query count, error count, minimum count, maximum count, minimum time, maximum time, and average time (in ms) taken by the query. It also displays tier, server, and instance. On clicking the query name, the complete query is displayed in the Query text area.

Further Reports in this Section

The user can view further reports from this window by clicking the specified links.

  • To view the flowpath report, click the Query Count link.

Exception

Exception instance report displays detailed information on the exception occurred, such as exception trend, aggregate exceptions (exception class, throwing class, throwing method, and exception count), exception details (tier, server, instance, integration point, time, exception class, message, throwing class, throwing method, line method, and cause), stack trace, and source code.

Note: The exceptions are captured for .NET, Java, and NodeJS agents.

Exception Stats

This section displays two sub-sections. One for group by exceptions where percentage of exception groups (such as PSQLException and NumberFormatException) is displayed and another is exceptions where exception stats (exception by time at X-axis and exception by count at Y-axis) is displayed.

Aggregate Exception(s)

This section provides aggregated details of the exception(s), such as exception class, throwing class, throwing method, and exception count.

Exceptions

This section displays details of an exception. To view details of a particular exception class, click the exception counts within the Aggregate Exception(s) section. The details include tier, server, instance, integration point, time, exception class, message, throwing class, and throwing method.

Stack Trace

This section displays stack trace that contains stack data. On clicking a record from the left, source data is displayed at the right.

User can perform further actions from this section:

  • To view recorded variables, click the  icon.
  • To copy source code, click the  icon.
  • To download method body, click the  icon.
  • To download class file, click the  icon.

Method Timing

This report provides an intuitive view of the methods with their execution timings. This helps in getting the information, such as which methods is taking more time in the execution and causing an issue in the overall execution of the query or business transaction.

To view the method timing report, click the method timing link on the drill-down queries page or the response time in flowpath window (for particular flowpath instance). The Method Timing Report window is displayed:

This report displays the details of method timings in the form of Pie chart. It also displays the summary of methods that contains package, class, methods and their associated time of execution. Here, user can identify which method is taking huge amount of time to execute.

Description of terms in the method timing report:

  • Percentage: Percentage of total time taken to execute all invocations of method
  • Self-time: Time taken for invocation of a method excluding the time taken by inner methods
  • AvgSelfTime: Average self-time taken for single invocation of method
  • CumSelfTime: Total self-time taken for all invocations of method
  • CumWallTime: Total time taken for all invocations of method
  • AvgWallTime: Average time taken for all invocations of method
  • CumCpuTime: Total CPU time taken for all invocations of method
  • AvgCpuTime: Average CPU time taken for all invocations of method
  • CumCpuSelfTime: Total CPU self-time taken for all invocations of method
  • AvgCpuSelfTime: Average CPU self-time taken for all invocations of method
  • WaitTime(ms) : Any thread consuming time on wait method
  • SyncTime(ms) : Any thread stuck before synchronized block or synchronized method due to lock not available
  • IOTime(ms) : Thread pause time due to input/output operations.
  • SuspensionTime(ms) : Thread pause time due to java GC.
  • Count: Number of invocations of a method

From this window, user can perform following operations:

  • View summary of all methods
  • View summary of all classes
  • View summary of all packages
  • View compare report
  • View dashboard

To get the method timing breakdown under method call details (i.e. time taken in wait, sync, IO, and others), enable the ‘Method and Business Transaction Level’ check box. To enable this check box, do the following:

1. On the left pane, go to Configuration > Agent Config.

2. On the Agent Config home page, click Profile.

3. Select the desired profile, and then click Flowpath under ‘General Settings’.

4. Under the Flowpath tab, against ‘Capture Time Breakdown’ select the Method and Business Transaction Level option, and then click Save.

FlowPath

Click the FlowPath link on System Queries window to view the FlowPath report.

This window contains information, such as Business Transaction, URL, Category, Start Time, Response Time (ms), Methods, URL, Status code, number of CallOuts, CallOut Errors, Category, CPU Time (ms), Parent FlowpathInstance, Total CPU Time (ms), and others.

Description of terms used in FlowPath Report:

  • Tier: This denotes the name of the tier.
  • Instance: This denotes the instance running on that tier.
  • Business Transaction: This denotes the name of the business transaction executed on the instance, such as purchasing an item, transferring funds, or tracking an order. On clicking this link, user can view Flowpath details/ method calling tree.
  • URL: It denotes the page URL of the business transaction. On clicking this link, user can view HTTP report.
  • Category: It denotes the category of business transaction, such as normal, slow, very slow. On clicking this link, user can view HotSpot report.
  • Start Time: This denotes the start time of the business transaction or method
  • Response Time: This denotes the time taken in the execution of business transaction. It is in MM/DD/YY HH:MM:SS format. On clicking this link, user can view Method Timing report.
  • CPU Time: Time spent by CPU to execute method or transaction.
  • Methods: It denotes the number of methods executed for that business transaction.
  • CallOuts: It denotes the number of calls for that method. On clicking this link, user can view transaction flow map.
  • CallOutErrors: It denotes the number of errors occurred in the method invocation. On clicking this link, user can view exceptions for error callout.
  • DB Call Count: This denotes the database call counts. On clicking this link, user can view DB request report.
  • Status: This denotes the status/response code of the business transaction, such as 200, 500.
  • CorrID: This denotes the correlation ID.
  • WaitTime(ms) : Any thread consuming time on wait method.
  • SyncTime(ms) : Any thread stuck before synchronized block or synchronized method due to lock not available.

Further Reports from this Window

  • To view IP Summary, click the Business Transaction link
  • To view HTTP Report, click the URL link
  • To view Hotspot report, click the Category link
  • To view Method Timing report, click the Response Time link
  • To view Method Call details, click the Methods link
  • To view End-to-end transaction FlowMap, click the Callout link
  • To view DB report, click the DB Callouts link

Apart from this, flowpath window displays various icons through which a user can perform various functions:

SR. No. Icon Description
1 Copy flowpath link
2 Show all flowpaths of selected flowpath’s session
3 Show all flowpaths of selected flowpath’s NV session
4 Open NV Session
5 Open Executive Dashboard
6 Open aggregate flowpaths of selected flowpaths
7 Download as PDF report
8 Download as Word report
9 Download as Excel report
10 Start auto instrumentation
11 View Metadata
12 Compare flowpaths
13 Delete Cached Data

Copy FlowPath Link

The user can copy flowpath link of the selected flowpath by clicking the  icon.

A message is displayed for successful copy of the flowpath link.

Show All FlowPaths of Selected Flowpath’s Session

The user can view all the flowpaths of the selected flowpath session by clicking the  link.

Show All Flowpaths of Selected Flowpath’s NV Session

The uses can view all flowpaths of selected flowpath’s NV session by clicking the  link.

Open Application End-to-End View

On clicking the button, the user can view the Application End-to-End View for the selected business transaction. The details of the Application End-to-End View are provided in the later section.

Open Aggregate Flowpaths of Selected Flowpaths

This operation is used to aggregate the method timing of Flowpaths. To perform this operation, select two or more Flowpaths and click the Aggregate Method Timing icon . The Aggregated method timing report is displayed.

The information of method timing is displayed in the form of a pie chart.

The user can also view the summary of methods in tabular format at the lower pane of the window. It contains package, class, methods and their associated time of execution. To view the details of an individual method in tabular format, click that method on the pie chart.

Description of terms in the method timing report:

  • Percentage: Percentage of total time taken to execute all invocations of method
  • Self-time: Time taken for invocation of a method excluding the time taken by inner methods
  • AvgSelfTime: Average self-time taken for single invocation of method
  • CumSelfTime: Total self-time taken for all invocations of method
  • AvgCpuSelfTime: Average CPU self-time taken for all invocations of method
  • WaitTime(ms) : Any thread consuming time on wait method
  • SyncTime(ms) : Any thread stuck before synchronized block or synchronized method due to lock not available
  • IOTime(ms) : Thread pause time due to input/output operations.
  • SuspensionTime(ms) : Thread pause time due to java GC.
  • Count: Number of invocations of a method

The user can view following other reports via this window:

Icon Description
To start Auto instrumentation
To exclude Level1 Flowpaths
To view summary of all packages
To view summary of all classes
To view summary of all methods

Start Auto Instrumentation

On clicking the  icon, the user can start auto instrumentation. The details of auto instrumentation is provided in the later sections.

View Metadata

When a user clicks the View Metadata  icon, metadata report is displayed. This report contains the details of all metadata and mapping of Tier, Server, and Instance as per the topology in tabular form. The mapping section is displayed by default.

Mapping

This section contains three tables that have the mapping of Tier, Server, and Instance as per the topology.

Metadata

This section contains 10 tables, which have the following details:

  • Tier
  • Server
  • Instance
  • Package
  • Class
  • Method
  • Backend
  • Tables Records
  • BT
  • Query

A user can update the tables from DB by clicking the Refresh  icon.

Compare Flowpaths

This operation is used to perform comparison between two Flowpaths. To do this, select two Flowpaths for which the comparison is to be done, and click the Compare Flowpaths icon .

This window displays Flowpaths details, such as tier, instance, business transaction, start time, response time, number of methods, URL, Status, CallOuts, CallOut Errors, Category, and CPU time.

In the Flowpath comparison section, user can view the comparison of various entities, such as transaction flow, method timing, DB report, sequence diagram, Hotspot, method calling tree, and exception.

Delete Cached Data

On clicking the  icon, the user can deleted the cached data for the following components:

Exception Instance Report for Selected Flowpath

Exception instance report displays detailed information on the exception occurred, such as exception trend, aggregate exceptions (exception class, throwing class, throwing method, and exception count), exception details (tier, server, instance, integration point, time, exception class, message, throwing class, throwing method, line method, and cause), stack trace, and source code. To view the exception instance report for a particular flowpath, select the flowpath, and click the  icon in Flowpath report window.

There are various sections in this window:

Exception Trend 

Aggregate Exceptions 

Exception Details

Stack Trace

 

Source Code

User can download the source code also. All these reports can be downloaded in Word, Excel, and PDF format.

Open NV Session

In this section, user can view the NetVision session of the selected flowpath. To view NV session, select a flowpath and click the  icon. This displays the NV session along with various details:

Page

The user can also view the Page Summary report from Drill Down Queries window. This window displays the following page summary details: Page name, number of tries, success, and failures. It also displays minimum, maximum, average, and median duration of the page along with 80th percentile, 90th percentile, 95th percentile, 99th percentile, fail percentage, and script count.

Other Reports from this Window

  • To view the page instance report, click the Tried link
  • To view the page failure report, click the Fail link
  • To view the page component detail report, click the Average link
  • To view the page session summary report, click the Script Count link

Hotspot Report

This report is used to find out a thread that is taking more time in execution or was stuck in the processing. This may cause a spike in the graphical representation of the processing. To view the Hotspot thread details, click the Category link on the flowpath report window. The Hotspot thread details window is displayed.

Following details are displayed in this window:

  • Thread ID: Unique Id of the thread
  • Hotspot Entry Time: Start time of the hotspot
  • Hotspot Duration: Duration of the hotspot in seconds
  • Thread State: Current state of thread, such as runnable, timed_waiting, blocked, running etc.
  • Thread Priority: It is the priority of thread, such as 1, 2, 3 and so on. Threads with priority 1 are executed first and so on by JVM.
  • Stack Depth: Number of methods within the stack defined the depth of the stack trace captured for hotspot.

Another section in this window displays the detailed stack trace, this displays the method execution time.

At the bottom of Hotspot report, there is Integration Point Calls section that displays integration point call details, such as IP name, discovered IP name, type of IP, start time, duration, status, and query.

Clicking on the IP name navigates the user to Integration point health section.

This window displays various information on integration points, such as average response time (ms), maximum response time(ms), response time trend, Calls per second (CPS), CPS trend, total number of calls, total errors, and error trend.

It also displays expanded view of response time trend, CPS trend, and error/sec trend.

HTTP Report

HTTP report displays details on various sections, such as http details, request header, condition headers, response headers, session attributes, and derived data. To view the HTTP report, click the URL link on the Flowpath report window. The HTTP Report is displayed.