Skip to main content

 

ThoughtSpot

System Monitoring

Overview

Explains what the feature is or what its benefits are to the user or customer.

Feature

System monitoring tools in ThoughtSpot include the Control Center, system log files and out-of-the-box system monitoring pinboards.

System Monitoring Notifications

You can configure ThoughtSpot to send emails to addresses you specify with monitoring reports and a cluster heartbeat. Follow these steps to Set Up Monitoring.

Control Center

The ThoughtSpot application includes a Control Center, for easy monitoring of usage and cluster health, including alerts. You can view the Control Center by clicking on the Administration icon and then clicking System Health.
File:02_Administration/Administrator_Guide_3.1/0A0/010/control_center_show.png

Getting to the Control Center

The Control Center shows the following information:

The Overview section shows a summary of overall cluster status, usage information, configuration changes, and critical alerts.

File:02_Administration/Administrator_Guide_3.1/0A0/010/control_center_overview.png

Partial View of the Control Center: Overview

The Data section shows all the stored tables with details on the last update time, time taken for auto-indexing, number of rows, etc.

The status columns have these possible values and meanings:
Table 1. Control Center: Data section statuses and meanings
Section Status Meaning

Database

READY

The data has been loaded.
  IN PROGRESS The data is still being loaded.
  STALE The data is not up to date.
  ERROR The table is invalid. Call ThoughtSpot Support.
Search

READY

The data is up to date and searchable.
 

NOT READY

The data is not ready to be searched.
 

DELETING INDEX

The table has already been deleted, but the index still exists due to the latency between the database and search engine.
  INDEXING DISABLED Either too many tokens exist in a column for it to be indexed, or indexing has been disabled manually.
  CREATING INDEX The index is being created.
  UPDATING INDEX A change has been made to indexing or the data, and the index is being updated to reflect it.

File:02_Administration/Administrator_Guide_3.1/0A0/010/control_center_data.png

Partial View of the Control Center: Data

The Cluster Manager section show detailed information about a cluster including latency over time, snapshot status, installed release, node functions, and logs.

File:02_Administration/Administrator_Guide_3.1/0A0/010/control_center_cluster_mgmt.png

Partial View of the Control Center: Cluster Manager

The Events and Alerts section shows notifications, alerts, and an audit trail of cluster configuration changes..

File:02_Administration/Administrator_Guide_3.1/0A0/010/contro_center_configuration_events.png

Partial View of the Control Center: Events and Alerts

System Monitoring Pinboards

There are several system monitoring pinboards in ThoughtSpot that include information about the system status and resource usage. The information in these pinboard is updated hourly from an internal database that collects monitoring statistics.

File:02_Administration/Administrator_Guide_3.1/0A0/010/resource_usage_pinboard.png

Example of a system monitoring pinboard

The monitoring pinboards can only be viewed by users with the administrator privilege. They are based on worksheets, which administrators can view, but not modify. The underlying tables are protected system tables that cannot be accessed directly. However, you can create new monitoring reports from the worksheets.

The worksheets for system monitoring are:
  • Ts: bi server
  • Ts: database
  • Ts: loader
  • Ts: search
  • Ts: service resources

Here is a list of the system monitoring pinboards:

Table 2. Monitoring pinboards
Pinboard Description Examples
TS Stats: Usage Helps you see how much the system is being used. Shows question, answer, and pinboard activity by user and by date.
  • Questions asked by user
  • Questions asked by date
  • Pinboard impressions
TS Stats: Suggestions Helps you monitor the performance statistics for the suggestions provided in the search bar. Shows the number and latency of suggestions given over time.
  • Suggestion volume over time
  • Suggestion latency over time
TS Stats: Queries Helps you monitor database performance over time by showing query volume, latency, and any errors.
  • Query latency by size of response
  • Average vs. maximum query latency
  • Database queries and errors
TS Stats: Resource Usage Helps you monitor cluster resources by showing memory and CPU usage per component:
  • Service
  • Database
  • Search
  • Host
  • Aggregate (all)
  • CPU usage per component over time
  • Memory usage per component over time
  • Aggregate memory usage over time

Log Files

Many of the administration commands output logging information to log files. The logs get written into the fixed directory /export/logs, with a sub-directory for each subsystem. The individual log directories are:

  • /export/logs/orion
  • /export/logs/oreo
  • /export/logs/hadoop
  • /export/logs/zookeeper
  • Was this article helpful?