Using DynaTrace Application Performance Management with Denodo

Applies to: Denodo 6.0 , Denodo 5.5
Last modified on: 25 Oct 2016
Tags: Tomcat Administration Performance Monitoring

Download document

Goal

This article shows how to integrate DynaTrace with the Denodo Platform, including the embedded Tomcat container and the VDP server.

DynaTrace Configuration

DynaTrace is an application performance manager which can be used to manage the availability and performance of many software applications.

To install DynaTrace choose the installer that suits the architecture of the destination operating system you will find installers for Microsoft Windows and Linux both for 64 and 32 bit.

Once DynaTrace has been installed some configuration changes need to be made. By default DynaTrace agents use the 9998 port. This port is one of the default ports used by the VDP server. We will change the port used by DynaTrace to 19998. From the DynaTrace client:

  1. Go to Settings > dynatrace Server…
  2. Go to Services > General. Check the “Allow Agent Connections to dynaTrace Server” and edit the Listen Port to 19998:

  1. The configuration of the DynaTrace Collector needs to be changed to. Go to Collectors,  Select the collectors in the list and edit the port under “Listen for dynaTrace Agent at” to 19998 and then click on Restart to restart the collector.

Make sure to restart the DynaTrace server after these changes.

Denodo Platform Configuration

It is possible to monitor both the Virtual Data Port Server and the embedded Tomcat Container with DynaTrace.

Virtual DataPort

To monitor Virtual DataPort:

  1. Go to the DynaTrace Client.
  2. Click on Configure > Configure Environment and select “Web / Java / .Net” and then “Application Servers” in the screen that shows up.
  3. Select Application > Java in the “Configure Application Servers” dialog. Enter “VDP” as tier name.
  4. In the next step select if the VDP server is running on the local machine or a remote one. Select “5.0 or later” with the architecture that suits the system (32 or 64 Bit) and then select “Embeded dynaTrace Collector.
  5. When you click on Next Dynatrace will generate a string that has to be added to the JVM  options of the Virtual DataPort server. To add it to VDP:
  1. Open the Denodo Platform Control Center.
  2. Click on Configure.
  3. Click on JVM Options.
  4. Copy the DynaTrace agent string and append it to the “Virtual DataPort server /ITPilot Wrapper Server JVM” options.
  5. Confirm the changes and restart the VDP server.
  1. Click Next on the DynaTrace wizard to complete the configuration. After a few seconds DynaTrace will start monitoring the VDP server.

NOTE: The above configuration only changes the startup of the Virtual DataPort server when manually started from the Denodo Control Center or from the command line. To allow the monitoring when starting VDP as a service follow these steps:

  • Edit the DynaTrace agent string:
  • Scape the “,”, “:” and “=” characters with a “\” character and the backslash character “\” separating the folders must be replaced with the “/” character.
  • Add the agent string to the service.conf file under <DENODO_HOME>/bin. 

For example, the agent string:

-agentpath:"C:\Program Files\agent\lib\dtagent.dll"=name=VDP_Monitoring ,server=host:19998

must be added to the service.conf file as:

wrapper.java.additional.#="-agentpath\:"C\:/Program Files/agent/lib/dtagent.dll"\=name\=VDP_Monitoring \,server\=host\:19998", where wrapper.java.additional.# must have the following number in the sequence of additional options.

Tomcat

To configure the internal Tomcat web container:

  1. Go to the DynaTrace Client.
  2. Click on Configure > Configure Environment and select “Web / Java / .Net” and then “Application Servers” in the screen that shows up.
  3. Select Application Server > Apache Tomcat 5+ in the “Configure Application Servers” dialog. Enter “Tomcat” as tier name.
  4. In the next step, If the Denodo Platform is installed locally, choose “On this machine”, if not you can set up your remote machine.
  5. Select “5.0 or later” with the architecture that suits the system (32 or 64 Bit) for the “JVM Version” and then select “Embedded dynaTrace Collector.
  6. Click on Next and the wizard will show you a configuration line add to the Java application startup.
  7. Go to <DENODO HOME>/resources/apache-tomcat/bin and open catalina.bat with a text editor.
  8. Find the line set CATALINA_OPTS=%CATALINA_OPTS% %CATALINA_OPTS_JMX% and add the append the configuration string to the set CATALINA OPTS line:

set CATALINA_OPTS=%CATALINA_OPTS% %CATALINA_OPTS_JMX% -agentpath:"C:\Program Files\agent\lib\dtagent.dll"=name=Tomcat_Monitoring,server=host:19998

  1. Restart Tomcat.
  2. Click on next on the DynaTrace wizard. After loading, it will find Tomcat and you will see Tomcat information from DynaTrace.

How to configure DynaTrace to work with VDP over JMX

Denodo Platform implements a JMX interface to make available data useful for monitoring. It is possible to configure DynaTrace to get this information:

  1. Open DynaTrace and start VDP.
  2. From the DynaTrace client, click on Configure and then select the Advanced Configuration option.
  3. From the System Profile Preferences dialog click on Measures, and then on the  Create Measure button.

  1. Select Custom JMX Measure, which is located under Server Side Performance - Agent based Measures - Custom JMX.

 

  1. Click on Browse Metrics and select the metric that you want to monitor. Click on Pick Agent and select VDP, a list of the available metrics will show up in the left panel. Select, for instance, com.denodo.vdp.management.mbeans > VDBServerManagementInfo > ActiveConnections and Click Ok and then Add.

  1. The same process can be repeated to create more Measures.
  2. To configure DynaTrace to show charts for this custom measure click on Dashboard > Add Dashlet, select Chart in the dialog and click on Finish.

  1. It will create an empty chart, so it is necessary to add a series.
  2. Click on Add Series on the empty chart select Server Side Performance > Agent based Measures > Custom JMX, and the measure to display in the chart, in this example ActiveConnections, and then click on Add and Close.

  1. The DynaTrace will display information about the selected Virtual DataPort measures.

Questions

Ask a question
You must sign in to ask a question. If you do not have an account, you can register here

Featured content

DENODO TRAINING

Ready for more? Great! We offer a comprehensive set of training courses, taught by our technical instructors in small, private groups for getting a full, in-depth guided training in the usage of the Denodo Platform. Check out our training courses.

Training