Monitoring Report Queries

InetSoft's Style Intelligence provides a simple interface for report queries that allows users with minimal experience to full access to administrative level tools. View the information below to learn more about this powerful reporting software.

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:

#1 Ranking: Read how InetSoft was rated #1 for user adoption in G2's user survey-based index Read More


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.

why select InetSoft
“We evaluated many reporting vendors and were most impressed at the speed with which the proof of concept could be developed. We found InetSoft to be the best option to meet our business requirements and integrate with our own technology.”
- John White, Senior Director, Information Technology at Livingston International

To terminate an executing query, click the corresponding 'Select' box to select the query, and then click the 'Remove' button.
The 'Cache' page under the 'Monitoring' node provides key information for both the report cache and the data cache. 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:

Pages

The number of report pages cached in memory or disk.

Data Objects

The number of dataset rows cached in memory or disk.

Hits

The number of cache hits. A hit occurs when a query is performed against the cache and a match is found. (Requires 'Monitoring Level' set to 'High' on the 'Settings' page.)

Misses

The number of cache misses. A miss occurs when a query is performed against the cache and no match is found. (Requires 'Monitoring Level' set to 'High' on the 'Settings' page.)

Swapped

The number of bytes swapped from disk to memory, or from memory to disk. (Requires 'Monitoring Level' set to 'Medium' on the 'Settings' page.)


Previous: Report Generation