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.
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:
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.