Intellicus Enterprise Reporting and Business Insights 18.1

Performance Monitor

0 views June 28, 2020 0

Performance Monitor is the tool used to analyze and understand the impact of Intellicus workload on the system resources. It works by capturing snapshots of resource utilization at the specified interval.

Performance Monitor displays status of processes that are critical to Intellicus’ performance.

With Intellicus performance monitoring, data is collected for all activities in real time. For example, each time a user logs on or runs a report or query, the activity is tracked as it happens. The real-time data makes it easier to identify performance problems and non-optimized areas of the system.

Click Navigate > Administration > Monitor > Performance Monitor tab to open the Performance Monitor page.

The list of IPs on the left of the page, are the report server(s) running. Click the server IP to get the details on right side of the page.

You can see the number of threads used by the Report Server like report execution threads, threads used for communication between server and clients, threads used for report run request from dashboard, etc. You can also view RAM utilized on the selected Report Server, version of JRE installed on Report Server, name and version details of OS running, time for next audit log purge and next cache purge.

You can view used, allowed etc. values for various entities on mouse hover. Also, these values are indicated in colors across all sections of Performance Monitor.

Performance Monitor
Figure 1: Performance Monitor page

Navigation across Performance Monitor

Refresh All

Click Refresh All button to refresh all the information on Performance Monitor page.

Performance Monitor also auto-refreshes at a set time interval.  This can be set from Administration > Configure > Portal Menu page on the portal.

Queue Info

Click Queue Info link to jump to Request Queues section of Performance Monitor.

Connections

Click Connections link to jump to Connection Pools section of Performance Monitor.

Requests

Click Requests link to jump to Request Level Info section of Performance Monitor.

The list of IPs on the left of the page, are the Intellicus Report server(s) and cluster servers currently configured through Load balancer. Click the server IP to get the details on right side of the page.

We will discuss more about Queue Info, Connections and Requests sections later in this document.

Refresh button refresh button

All the sections have Refresh button on section header. Click refresh button button to refresh information on respective section.

Clicking the Top hyperlink would take you to the top of the Performance Monitor screen.

Threads Pool

Knowing when jobs are queued up waiting for threads from a job pool is very helpful for identifying and resolving performance bottlenecks.

Threads pool
Figure 2: Threads pool section

You can see the number of threads used by the Report Server for below jobs:

Reports

These are report execution threads.  These are used when a report run, export etc. request is served.  One thread will be used each time a report is run.

Dashboards

These threads are used when a report run request coming from dashboard is served.  One thread will be used for each of such request.

OLAP

These are the threads that are used to design/view OLAP reports and perform OLAP operations.

DEFA

These threads are used while receiving data from the forwarding agents.

Services

These are the threads that are used for communication between Intellicus server and clients.

Scheduled Jobs Thread

These threads are used when a report execution and delivery is scheduled.

Permalinks Thread

These threads are used when viewing links over entities like saved reports etc.

Each thread pool has the below indicators:

Minimum Allowed: A marker on the indicator marking minimum number of threads that will be used.

Maximum Used: A marker on the indicator marking the maximum number of threads used after Intellicus server was started.

Maximum Allowed: A marker on the indicator marking maximum number of threads that can be used.  This number is controlled by license.

Memory Utilization

This section indicates the RAM utilized out of the total memory available on Report Server.

memory utilization
Figure 3: Section of memory utilization

Report Server System Info

Provides version of JRE installed on Report Server, name and version details of OS running on Report Server, time for next audit log purge and next cache purge.

Report Server System info
Figure 4: Report Server System info section

Request Queues

Maximum number of threads that can be executed is limited by set properties and license.  If the number of threads are less than or equal to the maximum number, they are executed.  All additional threads are queued.

Request Queues
Figure 5: Request Queues section

Information about following queues are displayed:

  • Pending: Number of pending requests in the main pending queue.
  • Execution: Number of pending requests in Execution queue.
  • Scheduler: Number of pending requests in Scheduler queue.
  • Services: Number of pending services threads.
  • Dashboard: Number of pending requests in Dashboard queue.

Connection Pools

This section provides following information for each of the data connection:

  • Name: Data connection name.
  • Database user: The user ID used to login in the database.
  • Pool Status: Chart indicating use / availability of threads on a connection. Chart indicates initial pool size, maximum used and maximum allowed.
  • Metadata Cache Status: Displays metadata caching status of Table, View, Procedure etc.:
    • Cached: Caching completed
    • Caching: Caching is going on
    • Caching Due: Caching yet to start.
    • Caching failed: Intellicus tried caching metadata but could not.

Connection Pools
Figure 6: Connection Pools section

Request Level Info

The line chart shows the number of requests served at a time.  Number of requests served in 10 minutes of interval.  The chart is plotted based on information of last 100 minutes.

The table below the chart shows the requests currently being served.  You can click Kill button of respective row to stop the process.

Request Level Info
Figure 7: Request Level Info section

Configuring Audit Log functionality

Audit logs let you monitor the reporting activities taking place in Intellicus by enabling you to get a list of reports generated by different users and view the report outputs.

To enable Audit Log functionality, set report server property Audit Log to Enable.  To set this property, you need to go to Navigate > Administration > Configure > Server > Compliance.

Audit Log property
Figure 8: Audit Log server property

By default, Audit log is disabled.

When audit log is enabled, Intellicus starts saving report’s audit related information in repository.

Number of days for which this information should be maintained is set in a report server property Audit Log Purge Time.  For example, to maintain audit details for 45 days, set 45 as property value.  By default, it is 30 (days).

When a user generates an Intellicus report, intermediate report files (known as RPG files), are created and stored at server.  When you view snapshot of a report, report is generated from its RPG file.  The duration for which RPG files can be retained (so that report’s snapshot can be viewed) depends on value set in a report server property Audit RPG Purge Time.  By default, it is 7 days.

If Audit Log Purge Time is less than Audit RPG Purge Time, then all audit information will be deleted as per Audit Log Purge Time, but RPG file will not be purged.

When an RPG will be purged?

Purging of an RPG file depends on many server properties.  For example, if value of Audit RPG Purge Time is 7 days, but if that report is published for “ever”, such an RPG will never be purged.  However, this file will not be available for audit after corresponding log purge time is over.

Viewing Audit Log

To get a list of reports that were generated within a date range, go to the Audit Log page.  Click Navigate > Administration > Monitor > Audit Log.

Audit Log
Figure 9: Audit Log section on Monitor page

To get a log of reports generated,

  1. For a specific report, select its name or All to list all the reports.
  2. Select Organization/User (to get reports requested by a specific organization/user) or select All to list reports requested by all the users.
  3. Optionally, specify Date range in Date from and Date To.
  4. Click Refresh.

All the reports generated that meets the specified criteria will be listed.  For each report, the following detail is listed:

  • Report Name
  • Org Name
  • User Name
  • Action
  • Status
  • Time Stamp
  • Snapshot
To view snapshot or report

Each row in the table represents one report.

  1. Click the link in the Snapshot column of the row. The link indicates the output type.
  2. In View Options dialog, select options for the snap shot.
  3. Click OK to proceed.
To purge the log

Click Purge button to delete audit log information.