Document toolboxDocument toolbox

Viewing Kyvos Engines

Owned by Sarabjeet Kaur
Jul 17, 2024
4 min read

Applies to: Kyvos Enterprise  Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace   Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)

When you click the Kyvos Engines tab on the Activity Monitor, you can do the following:

Viewing BI Server and Query Engine details

Click the Kyvos Engines tab, and this shows the following information:

  • BI Servers: The BI Server section shows details of the Hostname, Instance name, Role, Process Memory Usage, Process CPU Usage, System Load Average, Service Thread Usage, Execution Thread usage, and Semantic Model Processing Thread Usage.

  • Query Engines: The Query Engine section shows details of the Hostname, Instance Name, Segment name, Capacity, Process Memory Usage, Process CPU, and System Load Average.

    image-20240124-130315.png

Here are the available choices when you right-click items in the different panes:

  • When viewing a list, right-click an item to view the available menu options.

    image-20240124-124551.png

    • Shows Details: displays the detail view in a new window. You can scroll to view all of the information, click Show Logs to view the logs, or click Close.

      image-20240124-124802.png

Note:

  • From Kyvos 2024.1 onwards, you can now see Kyvos Analytical Store statistics on the Activity Monitor. To view the Kyvos Analytical Store information, navigate to the Activity Monitor, then click the Query Engine. A detailed view dialog box is displayed. The information displays the total number of available Analytical Store connections and the number of connections currently being used. Users can also check the total amount of memory available and the percentage of memory used.

    image-20240124-130953.png

  • Show Logs: displays the information in a new tab.

  • Copy to Clipboard: lets you select a row or cell then copies the selected information to the clipboard to use elsewhere.

Viewing system health history

The system health history allows you to monitor the health of all BI Servers and Query Engines

Using this information, you can verify:

  1. If the number of threads executing in the system has suddenly increased in a particular duration

  2. If the number of open file pointers increased after execution of any particular job

  3. If the value of load average was deviating from its ideal value at any point in time

  4. If the heap memory utilization suddenly increased at any time

  5. You can also see all operations happening during a time period. For example,

    1. How many queries were running in parallel

    2. How many semantic model process jobs were running

    3. Any background thread (LDAP sync, purge, range balancer, etc.) was running

  6. Live Query Analyzer shows the following details (of BI Server and Query Engines which have served that query) when that query was running:

    1. Heap utilization

    2. Number of live threads

    3. Number of open file pointers

    4. d. Load Average

To monitor system health, perform the following steps. 

  1. From the Monitor, click Kyvos Engines, and then click View system health history. 

    image-20240124-123546.png

  2. The System Monitor dashboard is displayed in a new browser tab. Here you can see various process stats over a selected period of time. 

  3. Select the Event time duration and/or the sample Interval for which you want to see the stats.

  4. You can filter stats for BI Server and Query Engine using the Service Type filter.

  5. Use the Options button to Share via email or Export it as a PDF or Image file. You can also refresh the status from here.

The health monitor shows:

  1. Total Query Count

  2. Average response time

  3. BI Server and Query Engine System Stats for:

    1. Avg Threads Used

    2. Avg System CPU Usage

    3. Avg Load Average

    4. Avg Heap Memory Used

    5. Avg Open File Pointers

 

Copyright Kyvos, Inc. All rights reserved.