Denodo Monitor timings

Applies to: Denodo 8.0 , Denodo 7.0 , Denodo 6.0
Last modified on: 27 May 2020
Tags: Denodo Monitor Performance

Download document

You can translate the document:

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.

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