Denodo Monitor timings

Content

The Denodo Monitor is a command-line based utility for monitoring and auditing purposes. It can be located at <DENODO_HOME>/tools/monitor in a compressed zip file.

Note: Since Denodo 7.0, you can also find the Denodo Monitor as part of the Solution Manager in the folder <SOLUTION_MANAGER_HOME>/tools/monitor.

Denodo Monitor includes several types of “monitors” which obtain information from each server.

• Local monitors:

• They gather information about the machine where the Denodo Monitor is running.

• Server monitors.

• They obtain monitoring information by connecting to a server via JMX.

• VDP Queries monitor.

• It logs several parameters of all the VQL queries received by a VDP server.

The Virtual DataPort Queries monitor is specific to Virtual DataPort. It subscribes to the RequestsManagementInfo MBean, which sends a notification every time Virtual DataPort receives a query. The monitor stores the information contained in these notifications in <DENODO_HOME>/tools/monitor/logs/vdp-queries.log.

This log contains multiple information about the queries issued to a Virtual DataPort server. The following fields included in the log are related to timing information:

• startTime:

• Moment at which the query started its execution.

• endTime:

• Moment at which the query finished its execution.

It is important to keep in mind that the endTime may be different from the time when a client receives all the results of a query execution. This is because the endTime is the time when the query finishes its execution and sends rows to the client. Depending on the memory configuration, the server might have some rows in memory that are still pending to be sent to the client, so some rows might be waiting even when the query is completed and, depending on the speed of the client and the number of rows, the process might take some extra time.

Reference

Virtual DataPort Administration Guide: Denodo Monitor.