Introduction

AppDynamics provides a rich source of information about your monitored applications, including the performance of individual business activities, dependency flow between application components, and details on every business transaction in an instrumented environment.

AppDynamics APM provides a rich toolkit for turning the vast corpus of data captured by AppDynamics into valuable insights.

AppDynamics DEXTER (Data Extraction and Enhanced Reporting) can make this process even faster and simpler. DEXTER provides new ways to unlock the data stored in the AppDynamics platform. You can analyze this information in a number of data warehousing and visualization applications, and combine it with your own data to generate customized reports.

Turn Data Store into Data Warehouse

If you’re familiar with data warehousing terminology, think of DEXTER as an extract/transform/load (ETL) utility for AppDynamics data. It extracts information from the AppDynamics platform, transforms it into an enriched, query-able form for faster access, and loads it into variety of reports for:

1. Application logical model (applications, tiers, nodes, backends, business transactions)
2. Performance metrics (average response time, calls, errors per minute, CPU, memory, JVM, JMX, GC metrics)
3. Dependency data (flow maps, relationships between components)
4. Events (errors, resource pool exhaustion, application crashes and restarts, health rule violations)
5. Configuration rules (business transaction, backend detection, data collectors, error detection, agent properties)
6. Snapshots (SQL queries, HTTP destinations, data collectors, call graph data, errors)

By extracting the data from AppDynamics, converting it into queryable format and storing it locally, the data can be preserved with full fidelity indefinitely and interrogated in new and novel ways.

Scenarios Enabled by This Tool

Here are some scenarios that are possible with data provided by AppDynamics DEXTER:

1. Investigation of what is detected and reporting across multiple Controllers and multiple Applications
2. Evaluating what components (Tiers, Nodes, Backends, Business Transactions) are reporting and what load they have
3. Inventory of configuration in multiple environments
4. Comparison of configuration between multiple environments
5. Health Checks for On-Premises Controller – grabbing of data from for later investigation, when Controller is no longer accessible
6. Extraction and preservation of fine-grained Metric, Flow map and Snapshot data for interesting time ranges (such as load test, application outage, interesting customer load) with goal of investigation and comparison in the future
7. Visualization and correlation of Events, Health Rules Snapshots to the Metric data
8. Discovery and data mining of of Snapshots by the types and contents of the Exits (HTTP call and SQL query parameters), Data Collectors, entities involved (Tier, Backend, Error, Service Endpoint and Applications) and Call Graph data

The 3 part Walkthrough gives an overview and screenshots of the tool in action.

Example Reports

Entity Details

"Entity Timeline View" is part of Entity Details report that is generated for Application and all of its Tiers, Nodes, Business Transactions, Backends, Service Endpoints and Errors. It provides a single-pane view into many things, including:

1. 1-minute granularity Metrics in the 1 hour time frame for each hour in the exported range
2. Filterable list of Events and Health Rule Violations, arranged in the timeline of that hour, with details of the Event
3. Filterable list of Snapshots, broken by Business Transaction and User Experience, arranged in the timeline of that hour, and hotlinked to the specific Snapshot

Detected Entities

If you ever were presented with a large Controller (or several) full of unknown number of Applications, Tiers and Nodes, you will like the detail provided by Detected Entities report.

Entity Metrics and Graphs

Entity Metrics report shows summary and graphs for all Metrics for each and every detected Application, Tier, Node, Business Transaction, Backend, Service Endpoint, Errors and Information Point. This makes it very valuable in times when you want to rapidly assess hundreds of Applications, Tiers and Business Transactions and see which ones need your attention.

A scatterplot of Calls per Minute vs Average Response time is provided for all types of Entities, allowing you to see what items are both slow and frequently called:Per minute breakdown with ART vs CPM scatter:All Nodes JVM GC metrics

Snapshots Report

Have you ever wanted to find a snapshot that calls a specific Tier, Backend or Application?

How about the one that uses specific SQL query?

And how about the one that has a real Call Graph?

Or maybe also a special Data Collectors?

Or how about finding out how many times that special Query was slow in a given time range?

Or discover which classes and methods are called in which Snapshots?

How about all of the above, combined?

In Snapshots report you can do all of that, and more. Snapshot Exit Calls broken by time and duration:Snapshots with multiple Segments have an enhanced Waterfall view, with “^” caret character indicating exactly when in the Segment execution the Exit Calls occurred

Flame Graph and Flame Chart Reports

Using Flame Graphs and Flame Chart reports, is an ingenious and useful way to visualize many call graphs in single screen. Sum of all calls in Application for entire time rangeSum of all calls in Application with Time grouping /

Report

Configuration report provides information about Controller Settings and Application configuration. Here is an example showing non-default Agent Properties set on multiple Applications in multiple Controllers

Get Started

Documentation

If you are new to AppDynamics DEXTER and want an introduction, read through 3 part Walkthrough.

Learn how the tool works by reading Documentation in the project wiki.

Install and Run Application

Install Application, create Job File to specify what to do, and Run Application.

Review Results

You will see the results in the Output folder.

To understand what you are looking at, read Description of Excel Reports.

Support

If you need help with issues and/or intepretation of results, read Getting Support.

Other Location

AppDynamics DEXTER is hosted on AppDynamics GitHub area.

Download latest release from Releases section, (AppDynamics.DEXTER.#.#.#.#.zip)