Denodo Monitor timings

Content

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

Note: 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 information about the queries issued to a Virtual DataPort server. The following fields included in the log are related to timing information:

• startTime:

• The moment at which the query started its execution.

• endTime:

• The moment at which the query finished its execution.

It is important to remember that the endTime may differ from when a client receives all the results of a query execution. This is because the endTime is when the query finishes executing 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.

References

Denodo Monitor