HITMAP - Trace analysis

Through the Hitmap widget in Application dashboard, you can open the Trace analysis window to check the transaction list and step information of each transaction at once. Drag the desired area on the hitmap widget. The Trace analysis window appears that contains the transaction list and sub-steps of the selected area.

Info

To see the updates in the Trace analysis function released on July 25, 2023, see the following.

Tip

To classify and see only the transactions with errors, select Error on the upper right of the Hitmap widget in Application Dashboard and then drag the chart area.

Basic screen guide

• Transaction lookup count: You can see the number of transaction lists in the dragged area on the hitmap widget. You can query up to 1000 cases.

• Transaction classification: By separating Active Stacks, Multi-transaction, and errors, you can view the list.

• Transaction search: You can search the transaction list by transaction name, agent name, and error message.

• Sorting the list: You can sort the lists of transactions by the selected item by clicking a header column in the table.

• The transactions with errors appear in red in the list.

  

Tip

• You can place, add, or hide desired columns to the front of the list. For more information, see the following.

• If you drag another area in the Hitmap widget, a new trace analysis window appears. You can check it by comparing with the previous trace analysis window.

• The transactions that are viewed can be shared with other users. With the transaction selected, copy the URL address on the trace analysis window and deliver it to another user. Any user who has received the URL address can quickly see the same items by entering the URL address in the browser address bar.

  

Analyzing a trace

Select an item to view details from the transaction list. On the right of the screen, the detailed analysis of the selected transaction appears. In this state, if another transaction item is selected, the detailed analysis of the selected transaction item is changed.

To analyze the transaction performance, WhaTap collects and displays the properties such as name and client data, transaction performance, and detailed execution records for each section.

• In the area, the step data can be seen in various formats. Select a desired type of tab.

• In the area, you can see the basic information for transactions. The information matches the columns in the list on the left.

• : The statistical data window for the corresponding URL or each execution section appears. If you select Detail in the statistical data window, Statistics appears.

• By dragging to the left or right, you can adjust the screen size. This is useful when you want to see more information.

Note

• For more information about Statistics, see the following.

• If you click or , you can change the transaction list or analysis details to full screen.

The collected types of Step are as follows. The diagrams and texts are color coded.

• DB Connection step START-END

  It includes the performance for connection to RDB. Step information includes the name, response time, and error.

• SQL step START-END

  It includes the performance for JDBC SQL. Step information includes connection data, SQL statements, and errors.

• HTTP Call step START-END

  It includes the performance for the outbound HTTP service call. Step information includes URL, host, port, response time, and errors.

• Message step ADD

  While collecting traces, the message steps are used to collect the records of all irregular sections.

• Socket step ADD

  Step to represent the socket open.

• Method step START-END

  The method response time is traced.

Note

• In the WhaTap monitoring service, Step is used as the same meaning as Span.

• To see the updates in the Trace analysis function released on July 25, 2023, see the following.

Table view

In the Table view tab, you can see the transaction execution steps in chronological order.

• You can classify transactions by each execution section and see them in a diagram. Out of all elapsed times, you can quickly find the times spent for each section and the section that took the longest.

• If you select each section in the diagram, the corresponding table list appears where the step is located.

  

• Select Column: You can add or hide the memory accumulation and CPU accumulation data as columns in the table list. The columns are as follows:

  • No: Step occurrence sequence

  • Time: Start time of each step

  • Gap: There may be a difference between the waiting time from the step start to the next step and the elapsed time if delayed due to external issues.

  • Elapsed: Total elapsed time from the start to the end of each method

  • Contents: Execution details of the step

• TXT: You can download basic transaction data and execution data for each section in a text file.

• SQL: The basic transaction information and SQL execution data can be downloaded as a text file.

• : You can see only the table list, with hiding the transaction summary and diagrams. If you select , the hidden information reappears. This feature is useful when you have a long list of tables.

• If you select the SQL step, the SQL window appears to display parameters. For more information, see the following.

Record summary

To see the basic information for transactions, select the Record summary tab. You can see the basic information of the transaction, agent on which the transaction was performed, memory allocation usage, and client information.

Transaction properties

Classification	Properties	Description
Agent	Agent name (oname)	Agent object name
	Agent ID (oid)	Agent object ID
	Agent group name	Agent group name set with the okind option
	Agent Group ID	Agent group ID
	Agent server name	Agent server name set with the ondoe option
	Agent server ID	Agent server ID
	pcode	Identification code of the project registered in the WhaTap monitoring service
Transactions	Transaction ID	Transaction ID
	Start Time	Transaction start time
	Endtime	Transaction end time
	Elapsed Time	Transaction execution time
	HTTP Method	HTTP methods - GET, POST, PUT, HEAD, etc.
	HTTP Call Time	External HTTP call time
	HTTP Call Count	External HTTP call count
	Average DBC Time	DB connection time
	SQL Time	SQL Execution Time
	SQL Count	SQL execution count
	SQL Fetch Time	Time taken to retrieve records (may overlap or involve other logics)
	SQL Fetch Count	Number of the records retrieved from SQL
Multi-transaction	CallerUrl	Address of the parent transaction
	CallerPcode	Project code from which the parent transaction was collected
	CallerOid	Agent object ID of the parent transaction
	CallerOName	Agent name of the parent transaction
	CallerOkind	Agent group ID of the parent transaction
	CallerOkindName	Agent group name of the parent transaction
Resource	CPU usage time	CPU usage used by transactions
	Memory Allocation	Memory usage used by transactions
Client	Client IP	Client IP address
	Domain	Internet address assigned to the IP address that the client connected to
	WClientID	Client ID
	Country/Region	Client's country
	City	City in the client's country
	OS	OS environment in which the browser runs
	Client type	Browser type used by the client
	Client Name	Device name used by the client
	Status	HTTP status code for the client request
	Referer	Page address or incoming path used by the browser of the client
	Original URL/Transaction	Combination of transaction name and original URL. Original URL appears if the URL exists. Otherwise, the transaction appears.
	UserAgent	Browser used to extract client-related data

Note

• The collected data may differ depending on the application type, settings, and step type.

• WhaTap basically stores the client-related information. For more information about the agent settings for user data collection, see the following.

Tree view

To see the transaction execution steps in a tree format, select the Tree View tab. You can see the details of each transaction and its trace details, trace start time, step time, and call relationship. If you select each section of the diagram, the tree view of the step appears.

• View one line: You can arrange the tree format at intervals by displaying the texts displayed in the execution data for each section in a single line.

• View multiple lines: All the texts displayed in the execution data for each section, appear by wrapping words.

• Longest Route: The longest route can appear.

• Display Time Bar: The elapsed times are displayed in a bar chart.

• Display Time: The timestamps, gaps, and elapsed times for each segment are displayed in text.

  • 8 seconds or more: Excessive delay state is distinguished in red.

  • Between 3 and 8 seconds: Delay state is distinguished in orange.

  • Less than 3 seconds: Normal state is distinguished in blue.

• Hide Time: The time is hidden.

• : You can see only the tree view that hides transaction summary and diagrams. If you select , the hidden information reappears. This feature is useful when the tree view list is long.

• : A window appears where you can view SQL variables and HTTP queries. For more information, see the following.

Note

In case of start and step times, the time differences caused by the transaction call environment are corrected on the screen through traces and mappings in the parent transactions. Accordingly, there may be differences from the actual time data.

Multi-transaction

Multi-transaction indicates the transaction involving other agents or projects. In the Multi-transaction tab, you can see the call relationships between applications registered in the WhaTap monitoring service.

Tip

To trace multi-transactions, set the mtrace_enabled option to true in Management > Agent Settings. For more information about the agent configuration, see the following.

• Chart: Provides the call relationships for each transaction in a flowchart. Select a transaction node to see the trace analysis for the transaction node. In Chart mode, you can use the mouse to go to a desired position or zoom in or out by scrolling.

  • Chart view settings: You can display or hide the elements on the chart.

• Table: In the form of table, you can check the data for each transaction included in the multi-transaction. You can select the column selection icon to edit the table header columns. You can see the trace analysis data by selecting each transaction item.

• Tree: You can see the call relationships between transactions in a tree format. The related additional functions are the same as those of the Tree View tab.

• Select project: You can select or deselect projects to be displayed on the chart.

Note

• You can see them in the transaction list marked with the icon.

• For more information about the multi-transaction, see the following.

Methods

To see only the method data, select the Methods tab. It displays the method name and step time for which tracing has been set on the agent. When unnecessary logics are repeatedly executed, it can be used as analysis data to improve the method logic by finding the case where the execution takes longer than the low count.

Note

For more information about the agent configuration options on methods, see the following. Method tracing support may differ depending on the product in use.

SQLs

To check the SQL statement information, select the SQL summary tab. In case of unnecessarily repetitive execution, it can be used as analytical data to improve query performance by finding the case where the execution time takes longer compared to the low count.

HTTP calls

To see the count, time sum, average time, and such for HTTP calls, select the HTTP calls tab. If unnecessary external calls are repeatedly executed, it can be used as analytical information to determine whether the transaction delays are external or internal by finding the cases where the execution time takes longer compared to the low count.

Transaction log

To see the logs of the transaction, select the Transaction log tab.

• Keyword search: Enter the desired text to search in the keyword search field, and then press Enter or select the button. It highlights the keywords that match the entered text.

• Keyword highlight: If you set the keyword and color, the texts that match the keyword are automatically highlighted in the log list.

• Table settings: You can set the header columns in the log list table.

Note

• To enable the Transaction log tab, apply the agent setting options related to the logs. For more information about the log settings, see the following.

• The Transaction log tab can be accessed by only the members with the View log role. For more information about the member roles, see the following.

Setting the keyword highlight

1. To add keywords to highlight, select .

   

2. Enter a desired keyword.

3. Select the color icon and then select a desired color.

4. Press Enter.

The added keywords are added in the list.

Deleting the keyword highlight

To delete the items unused from the highlight list, select .

Displaying or hiding the table columns

1. Select on the upper right of the table.

2. From the drop-down menu, select Column Settings.

3. If the Column Settings window appears, select or unselect the desired items in the Add a Column section.

4. After all settings are finished, select OK.

The set content is applied to the table.

Reordering the table columns

1. Select on the upper right of the table.

2. From the drop-down menu, select Column Settings.

3. If the Column Settings window appears, drag a desired item in the Set column order section for reordering.

4. After all settings are finished, select OK.

The set content is applied to the table.

Setting to display the table content

1. Select on the upper right of the table.

2. From the drop-down menu, select Table Content Settings.

3. Set the following option:

   • Content Visibility: Select whether or not to display the content displayed in the table list.

   • Tag Management: You can select the desired tags to display in the table list. You can make them invisible or change their order.

4. After all settings are finished, select OK.

The set content is applied to the table.

Additional options

Viewing HTTP parameters

You can view the HTTP parameters of the transaction in the Table view tab.

1. Scroll down the page to the final step of the transaction.

2. Select the HTTP parameters item.

3. If the HTTP-PARAMETERS window appears, select Password.

4. Enter the specified Param Key.

You can see the hidden parameters.

Note

• For the agent settings for HTTP parameters, see the following.

• Password: You can see the decrypted parameter value. The password is a 6-digit string in the WHATAP_HOME/paramkey.txt file. You can change it to another string. The key in paramkey.txt is required to view the SQL variables and HTTP queries, and stop the threads.

Viewing SQL parameters

Select the SQL step in the Table view tab or select in the Tree view tab. The SQL window appears to display parameters.

• Password: You can see the decrypted value. The password is a 6-digit string in the WHATAP_HOME/paramkey.txt file. You can change it to another string.

  Note

  The key in paramkey.txt is required to view the SQL variables and HTTP queries, and stop the threads.

• SQL formatting: You can indent and format your SQL statements for better readability.

• : A SQL statement can be copied to the clipboard.

• Statistics: The SQL tab appears in STAT/REPORT > Statistics.

Tip

To search SQL variables and HTTP queries, add the following options to the agent settings.

• For agent settings related to recording SQL parameters, see the following.

• For agent settings related to recording the HTTP parameters, see the following.

whatap.conf

# SQL parameter lookup option: If the option is applied, SQL parameters are collected after being encrypted.
profile_sql_param_enabled=true 

// HTTP parameter lookup option: If the option is applied, HTTP query parameters are collected after being encrypted.
profile_http_parameter_enabled=true 

Configuring the table columns

In the transaction list, you can hide the table header columns or add any of them. You can also change the column order. Select Column Settings.

Note

• After configuration, select Confirm to apply the settings in the table.

• In the search bar, enter text to search the desired columns. Only the columns that meet the entered text are displayed.

Adding columns

From the list, select the items to add as table header columns. To select all items, select Select All.

Deleting columns

From the list, unselect the columns to delete. Alternatively, select on the right of the item to delete from the list.

Changing the column order

Drag an item to reposition from the list, and then move it to the desired position.

Initializing the configuration

To cancel all changes and reset them, select Initialized.

Downloading the viewed data

To download the data output in the table in .txt file format, select TXT.