USER MANUALS

Monitoring - Requests

The “Requests” tab displays information about the last requests processed by the Virtual DataPort server. The blurred rows represent queries that finished.

Requests tab of a monitored server

Requests tab of a monitored server

Right-click on a row to:

  • execution_plan Execution Plan: Displays the execution plan of the query in a new tab. You can click on each node of the execution plan to inspect the runtime information about it. This option is only available for requests of type SELECT VIEW, SELECT BASE VIEW, CALL PROCEDURE, QUERY WRAPPER, SELECT INTO, INSERT INTO or CREATE REMOTE TABLE.

    Execution plan tab of a request

    Execution plan tab of a request

  • tree_view Tree View: Opens a new tab with the tree view of the query, a static picture of the view dependencies of a query. The result of this action depends on the privileges the user account set on the server has over the views that participate in the query and on their dependencies. This option is only available for requests of type SELECT VIEW or SELECT BASE VIEW.

    Tree view tab of a request

    Tree view tab of a request

  • database Show Data Sources: Displays in a new tab information about the data sources that participate in the query. This option is only available for requests of type SELECT VIEW, SELECT BASE VIEW, SELECT INTO, INSERT INTO or CREATE REMOTE TABLE.

  • threads Show Threads: Displays in a new tab information about the threads that participate in the query and a graph with the query CPU usage. This option is only available for active requests of type SELECT VIEW, SELECT BASE VIEW, CALL PROCEDURE, SELECT INTO, INSERT INTO or CREATE REMOTE TABLE.

    Note

    Queries lasting less than 5 seconds will not show any CPU usage info on this graph.

    Threads tab of a request

    Threads tab of a request

  • relatedqueries Show Related Queries: Displays in a new tab information about the related sub-queries into which this query is divided.

    The fields that are available in the “Related Queries” table are:

    • User Agent: Name of the application that opens the session that this request belongs to.

    • Origin Query Id: Unique identifier for the original query.

    • Query: VQL code for the statement.

    • Start Time: Moment at which the request was started..

    • End Time: Instant when the request ended.

    • State: State of the top node of the execution plan. Find the

      possible values of this attribute in the table Values of the “State” attribute of the nodes of a query’s execution trace of the Administration Guide.

    • DataSource Name: The name of the data source from which the data was retrieved.

    • Access Interface: Type of client that performed the request. The

      possible values of this attribute are: Diagnostic-Monitoring-Tool, JDBC, JMS, JMX, ODATA, ODBC, SCHED, Solution-Manager, VDP, VDP-AdminTool, WS-REST, WS-REST-Generic and WS-SOAP.

    • Client Ip: IP address of the client that execute the statement.

      In case of web services, this is the IP address of the final client.

    • Client Provider: The service provider of the client’s network.

    • Client Region: The geographical region of the client.

    • DataSource Adapter: The adapter used to connect to the data source.

    • DataSource Database: Name of the Virtual DataPort database on which the

      statement is executed.

    • DataSource Provider: The provider of the data source.

    • DataSource Region: The geographical region of the data source.

    • DataSource Type: The type of data source.

    • Database Name: The name of the database involved in the query.

    • Estimate Row Size From VDP: Estimated size of rows returned from the Virtual DataPort.

    • Estimate Row Size To VDP: Estimated size of rows sent to the Virtual DataPort.

    • Estimated Num Bytes Read In Source: Estimated number of bytes read from the source.

    • Estimated Num Rows Read In Source: Estimated number of rows read from the source.

    • Estimated Query Result Row Size: Estimated size of each row in the query result.

    • Estimated Source Cost: Estimated cost associated with accessing the data source.

    • Exception: Details of any exception or error encountered during query execution.

    • Memory Limit Reached: Indicates if a memory limit was reached during the query.

    • Nested Join Right Access: Information about nested join right accesses.

    • Nested Total Right Accesses: Total number of nested right accesses.

    • No Delegation Causes: Reasons why query delegation did not occur.

    • Num Rows From VDP: Actual number of rows received from the Virtual DataPort.

    • Num Rows To VDP: Actual number of rows sent to the Virtual DataPort.

    • Query End Time: Specific time when the origin query concluded.

    • QueryResult Rows: The total number of rows in the query result.

    • Query Start Time: Specific time when the origin query started.

    • Query State: The detailed state of the original query.

    • Request Type: Type of statement. It can take the following

      values: ALTER, BEGIN, CALL PROCEDURE, CLOSE, COMMIT, CONNECT, CREATE, CREATE REMOTE TABLE, DELETE, DEPLOY, DESC, DESC SOURCE, DROP, EXPORT, HELP, INSERT, INSERT INTO, LIST, REDEPLOY, ROLLBACK, SELECT BASE VIEW, SELECT INTO, SELECT VIEW, SET, SHOW, UNDEPLOY, UNKNOWN, UPDATE, UPDATE SCRIPTS, USER MODE, VCS and WEBCONTAINER.

    • Response Time: The total time taken to receive a response for the query.

    • Session Id: Identifier of the session that this request belongs

      to.

    • Username: Name of the user running the statement.

  • cancel Cancel Request: Stops the request. This option is only available for active requests of type SELECT VIEW, SELECT BASE VIEW, CALL PROCEDURE, INSERT INTO or CREATE REMOTE TABLE.

The fields that are available in the “Requests” table are:

  • ID: Unique identifier of the request.

  • Start Time: Moment at which the request was started.

  • End Time: Instant when the request ended.

  • Duration: Number of milliseconds between the start and end time for the request.

  • Request Type: Type of statement. It can take the following values: ALTER, BEGIN, CALL PROCEDURE, CLOSE, COMMIT, CONNECT, CREATE, CREATE REMOTE TABLE, DELETE, DEPLOY, DESC, DESC SOURCE, DROP, EXPORT, HELP, INSERT, INSERT INTO, LIST, REDEPLOY, ROLLBACK, SELECT BASE VIEW, SELECT INTO, SELECT VIEW, SET, SHOW, UNDEPLOY, UNKNOWN, UPDATE, UPDATE SCRIPTS, USER MODE, VCS and WEBCONTAINER.

  • VQL Query: VQL code for the statement.

  • State: State of the top node of the execution plan. Find the possible values of this attribute in the table Values of the “State” attribute of the nodes of a query’s execution trace of the Administration Guide.

  • Uses Cache: true if the query has accessed the cache during its execution; false otherwise.

  • Num. Rows: Number of rows returned by the query.

  • Waiting Time: Number of milliseconds the query was waiting in the queue of queries before the Virtual DataPort server began executing it.

  • Elements: Name of the views and/or stored procedures referenced in the query and the database to which the views/stored procedures belong. This property has the format “<database name of the view/stored procedure>”.”<name of the view/stored procedure>”.

  • Session ID: Identifier of the session that this request belongs to.

  • VDP Database: Name of the Virtual DataPort database on which the statement is executed.

  • User: Name of the user running the statement.

  • Access Interface: Type of client that performed the request. The possible values of this attribute are: Diagnostic-Monitoring-Tool, JDBC, JMS, JMX, ODATA, ODBC, SCHED, Solution-Manager, VDP, VDP-AdminTool, WS-REST, WS-REST-Generic and WS-SOAP.

  • User Agent: Name of the application that opens the session that this request belongs to.

  • Uses MPP: Indicates if the request made use of Denodo Embedded MPP.

  • Client IP: IP address of the client that execute the statement. In case of web services, this is the IP address of the final client.

  • Web Service: Name of the web service, following the pattern “<database name>”.”<web service name>” (only for SOAP or REST Web services).

  • Transaction ID: Identifier of the transaction that this request belongs to (only if the statement is executed inside a transaction).

  • CPU Time: How much time has the request used the CPU in nanoseconds.

  • Avg CPU Usage: Average percentage of CPU capacity used by the query (0-100%).

  • Max CPU Usage: Maximum percentage of CPU capacity used by the query (0-100%).

  • Max CPU Usage Time: Instant in time in which the maximum CPU usage was achieved expressed as a date and time.

  • CPU Usage Std Dev: Standard deviation of the percentage of CPU capacity used by the query (0-100%).

The options that are available in the “Requests” table are:

  • Hide Internal Requests: Toggles the visibility of internal requests generated by the DMT, if checked the DMT Requests will be hidden, and will only be displayed if disabled.

  • Max Rows: Sets the maximum number of rows to be displayed in a table Requests.

  • Refresh Interval: Defines how often the data in the table is automatically updated.

Add feedback