AppDynamics Application Intelligence Platform

3.9.x Documentation

PDFs

Learn by Watching

Doc Maps

Skip to end of metadata
Go to start of metadata

This topic describes how to configure call graphs in the PHP agent.

Call Graph Settings

The Call Graph Settings window lets you configure thresholds that affect performance and how much detail about SQL statements to capture.

To access call graph configuration screens

1. In the left navigation pane, click Configure -> Instrumentation.

2. Click the Call Graph Settings tab.

3. Click the PHP Call Graph Settings subtab.

Whenever you create or modify a call graph setting in these screens, click the Save Call Graph Settings button to save your configuration.

Call Graph Granularity

You can control the granularity for call graphs using following settings:

  • For methods: To ensure low performance overhead, choose a threshold in milliseconds for method execution time. Methods taking less than the time specified here are filtered out of the call graphs.
  • For SQL calls: You can also specify a threshold for SQL queries. SQL queries taking more than the specified time in milliseconds are captured in the call-graphs.

To exclude internal functions from the call graphs, check the Exclude internal functions check box.

SQL Capture Settings

Often the SQL Calls section does not display the raw values in a SQL query, as shown in the following query:

INSERT INTO ORDERREQUEST ( ITEM_ID, NOTES ) VALUES ( ?, ? )

Replacing the literals in a query with parameter markers in this way is called normalizing the query.

Normalizing a query prevents display of sensitive data, such as social security numbers or credit card numbers, which are potential query parameters. Normalizing queries also helps to organize SQL data by flattening the parameter values for the query so that the statistics from different executions of the query can be aggregated and compared against one another.

However, during troubleshooting, you may want to display the values of the bind variables.

To configure SQL capture

1. In the Call Graph Settings tab, scroll down to the SQL Capture Settings section.
2. Select one of the following:

  • Capture Raw SQL: Select this option to see raw SQL data (this captures raw SQL data along with the parameter values). Raw SQL data includes prepared statement bind variables or raw statements. By default, the private SQL data and queries that take less than 10 ms are not captured.
  • Filter Parameter values: Select this option to filter all literal values (constants) out of the captured query.

3. Click Save Call Graph Settings.

Learn More