4.12.4  Queries

The 'Queries' page under the 'Monitoring' node provides key information about queries currently executing on the server. In a clustered environment, select a machine from 'Cluster Node' menu to view the monitoring statistics for that machine.

 

The page provides the following information:

Table 7. Query Execution

Query ID

A unique identifier.

Data Objects

The number of dataset rows cached in memory or disk.

Thread

The thread within which the query is executing. Click the link to obtain a stack trace.

Name

The name of the query, or of the worksheet/data model executing the query.

Asset

The name of the report or Viewsheet from which the query was executed.

User

The user who executed the query.

Rows

The number or query rows that have been processed. (Requires 'Monitoring Level' set to 'Medium' on the 'Settings' page.)

Age

The length of time that the query has been executing.

To terminate an executing query, click the corresponding 'Select' box to select the query, and then click the 'Remove' button.

See Also

Configuring Remote Monitoring, to accessing data from remote machine.

Configuring Monitoring Resolution, for information on setting the monitoring level.

<< 4.12.3 Viewsheets © 1996-2013 InetSoft Technology Corporation (v11.5) 4.12.5 Cache >>