Using JavaTM VisualVM

Java VisualVM is a JMX client included with the Java Development Kit (JDK) version 6 or higher. This section explains how to use VisualVM to monitor Virtual DataPort.

To run VisualVM, execute: <JAVA_HOME>/bin/jvisualvm


VisualVM is not included with the Denodo Platform. To obtain it, download the Java Development Kit (JDK). The Java Runtime Environment (JRE) does not include it either.

After launching it, install the “VisualVM-MBeans” plugin. To do this, click Plugins on the Tools menu. Click the Available plugins tab, select the “VisualVM-MBeans” check box and then, Install. In the wizard, click Next to proceed with the installation of the plugin.

JavaTM VisualVM: Installing the MBeans plugin

JavaTM VisualVM: Installing the MBeans plugin

After installing the plugin, connect to the JMX interface of Virtual DataPort. To do this, click Add JMX Connection on the File menu. In this dialog, in the Connection text field, enter <hostname>:9997. E.g.: localhost:9997.

Then, select Use security credentials, enter the credentials of an administrator user and click Ok. After this, there will be a new element in the list of processes on the left-side of JVisualVM. Double-click it to open it. You can check that you have opened the right process by making sure that in the “Overview” tab, the “Arguments” label starts with “com.denodo.vdb.vdbinterface.server.VDBManagerImpl”

By clicking the different tabs of the process, you can obtain several information about the Virtual DataPort server: CPU consumption, memory consumption, activity of the Java garbage collector, etc. In this section, we will talk about the specific information provided by Virtual DataPort through its MBeans.

Click the MBeans tab to see the MBeans published by Virtual DataPort. Virtual DataPort server.

Virtual DataPort MBeans: VDBServerManagementInfo MBean

Virtual DataPort MBeans: VDBServerManagementInfo MBean

The information and events provided by each MBean is described in the following sections.

The information and events regarding DML and DDL statements (SELECT, INSERT, UPDATE, DELETE, CREATE, etc.) are accessible via the MBeans of the category (see section Information and Events on the Running of Statements). Subscribe to that MBean clicking on the Notifications tab and then the Subscribe button to get information about the statements running on the server. From then on, every time the Server executes a statement, VisualVM will display a new notification in this tab.

To view details about a request, double-click its “UserData” cell. The data about each statement includes the type of statement executed (SELECT, INSERT, etc.), the user who has run it, the time at which it was run, the VQL statement, etc.

Attributes tab of the RequestsManagementInfo MBean

Attributes tab of the RequestsManagementInfo MBean

Add feedback