AppDynamics
Call Drill Downs – Appdynamics
A call drill-down contains details for that business transaction execution on a particular tier. It takes you to the code-level information for the transaction.
The contents of a transaction snapshot containing asynchronous segments look slightly different if you access the snapshot via the Business Transaction view or via the App/Tier/Node views:
- Initially the Business Transaction view only displays the originating segments for the transaction. You have the option to drill down into the asynchronous segments as desired.
- The App/Tier/Node views surface all the segments that are relative to that specific entity. Therefore you access one of these views, you can see all segments, originating and asynchronous.
Node Drill Down
The node drill down organizes diagnostic data among the following tabs:
- The Overview tab includes a problem summary, execution times, CPU time stamp, tier, node, process ID, thread name, etc.
- The Call Graphs tab lists call graphs showing the execution flow for the transaction on a given tier. For details, see Call Graphs.
- The Slow Calls and Errors tab lists all the slow method calls and calls that resulted in an error. You can use the Hot Spots slider to sort calls by execution time with the most expensive calls in the snapshot at the top.
- The Error Details tab exposes exception stack traces and HTTP error codes.
- The DB & Remote Service Calls tab shows all SQL query exit calls to databases and exit calls to other remote services such as web services, message queues, or caching servers. See Database queries and batching for more information about how AppDynamics handles SQL exit calls.
- The Server tab displays graphs for hardware—CPU Memory, Disk IO, Network IO— Memory—Heap, Garbage Collection, Memory Pools—JMX, and more. If you have Server Visibility, you will have access to full performance details for the server hardware and operating system
- For customers using Network Visibility, the Network tab shows charts related to the impact of the network on the transaction and other pertinent data. For information on network KPIs and troubleshooting see KPI Metrics in Network Dashboard and Application Flow Map and KPI Metrics in Right-Click Dashboards.
- The Data Collectors tab shows pertinent application data for the transaction snapshot. For configuration options, see Data Collectors.
HTTP Data: HTTP payloads contain basic data such as the URL and session ID, and additional data for Servlet entry points, Struts, JSF, Web Services, etc. You can use HTTP data collectors to specify which query parameter or cookie values should be captured in the transaction snapshot.
Cookies: The snapshot can use cookie values to help identify the user who initiated the slow or error transaction.
User Data: User data from any method executed during a transaction, including parameter values and return values, to add context to the transaction. You can use method invocation data collectors to specify the method and parameter index.
In cases where an exit call is made just before a business transaction starts, exit call information can show up in this field, particularly if the transaction is marked as slow or having errors. Please note that sensitive information on the exit call may be shown in this situation.
- The More tab shows how metrics for the node that deviate the most from the established baselines as Node Problems. It also shows all the Service Endpoints invoked during the snapshot and the Servlet URI and Process ID of the transaction.
Database Queries and Batching
AppDynamics normalizes SQL queries and by default does not display raw/bind values. You can configure SQL capture settings to monitor raw SQL data in the queries. Individual calls that take less than 1 second are not reported.
When returning data to a JDBC client, database management systems often return the results as a batched response. Each batch contains a subset of the total result set, with typically 10 records in each batch. The JDBC client retrieves a batch and iterates through the results. If the query is not satisfied, the JDBC client gets the next batch, and so on.
In the SQL query window, a number followed by an X in the Query column means that the query ran the number of times indicated within a batch. The value in the Count column indicates the number of times that the batch job executed.
Database Drill-down
Database drill-downs tell you the following about the transaction:
- Queries:lists the queries consuming the most time in the database as top SQL statements and Stored Procedures. Comparing the query weights to other metrics such as SQL wait times may point you to SQL that requires tuning.
- Clients: displays the hostname or IP addresses of the Top N clients using the database. A database client is any host that accesses the database instance.
- Sessions: displays the Session ID of the Top N sessions using the database sorted by time spent.
- Schemas: shows the names of the Top N busiest schemas on the database server.
View All Tiers and Nodes
To view the list of tiers and nodes, click Tiers & Nodes in the left application panel. The tier list shows all tiers and health data for each tier.
In the tiers list, the Machine Agent column indicates whether the Standalone Machine Agent is reporting to the Controller. If the Machine Agent is not reporting, the column is empty. In this case, either an agent is not installed or it is not reporting for some other reason.
You can change descending and ascending order of the list by clicking on any of the columns.
View Tier and Node Dashboards
In Tiers & Nodes, select a tier or node and click Details. The tier and node dashboards contain a flow map view at the tier or node level, including widgets for health statuses, load time, response time, and errors. The Memory tab shows memory information relevant to your application environment. Note that the specific information shown for each environment can vary, depending on the nature of the environment. PHP memory management is different than other languages. The relevant memory metrics supplied by the App Agent for PHP are in the Metric Browser.