Viewing the status of the data warehouse

Use the Status page to check the overall health and status of your data warehouse. The status includes the following details:

  • Alerts generated
  • Total and used space
  • Processing details, such as active threads and throughput
  • Volumes processed by the data warehouse components

You can use this information to monitor the health of your data warehouse so that it is always up and running.

To view the data warehouse status

  1. Log in to the TrueSight Capacity Optimization console.
  2. Click the Administration tab and click DATA WAREHOUSE > Status.
    The following status page is displayed:


The following table describes the Status page sections:

SectionDescription
Alerts

Displays diagnostic alerts related to the data warehouse.

Click the Diagnostic Alerts link to go to the Diagnostic alerts page and view more details.

Click Back to Warehouse status to view the Status page.

Space

The bar represents the total space of the filesystem used by the tablespace of the TrueSight Capacity Optimization database.

To ensure that the available space is utilized properly, click next to Total Available Space and specify how much space on the filesystem is available for tablespaces.

To view more details of the space usage, click Space Report.

Click Back to Warehouse status to view to the Status page.

Processing

Displays four color-coded squares that indicate the data warehouse status for the following:

  • Active Threads: Number of active threads in the data warehouse, that is threads that are actively doing data warehouse activities.
  • Average Throughput: The average processing throughput of all the data warehouse threads during the last 24 hours.
  • Daily and monthly rollup: The maximum processing time of the daily and monthly rollup of time series data.
  • Maximum Est. Proc. Time: The maximum estimated time that is spent in processing the active threads.

Yellow and red colors denote potential processing problems that you must analyze and resolve.

InformationStatusIndicates
Active threads

Green

The status of all active threads is good.

YellowThe warehouse is paused.
Red

One of the following issues:

  • At least one thread is in an error state.
  • At least one active thread exists with zero average throughput and the maximum queue age greater than 24 hours.
Average Throughput

GreenThe average throughput is within the expected limits.
YellowNA
Red

At least one active thread exists with zero average throughput and the maximum queue age greater than 24 hours.

Daily and Monthly Rollup

GreenThe total processing time is less than 18 hours.
YellowThe total processing time is more than 18 hours.
RedThe total processing time is more than 24 hours.
Maximum Est. Proc. Time

GreenThe maximum processing time is less than 24 hours.
YellowThe maximum processing time is between 24 hours and 48 hours.
RedThe maximum processing time is greater than 48 hours.

Click the Processing details link to go to the Viewing the near real-time status of the data warehouse components page and view more details.

Click Back to Warehouse status to view the Status page.

Volume

Displays values and charts for the following volumes processed by the TrueSight Capacity Optimization data warehouse components:

  • Processed today
  • Processed yesterday
  • Average daily processed rows (last 30 days)
  • Estimated daily capacity (8 hour period)
  • Estimated daily capacity (24 hour period)

The following image shows an example of the the Volume values and charts:

To view more details about the volumes, click Volume Report.

Click Back to Warehouse status to view the Status page.

Interpreting the Volume chart

You can quickly gauge the status of your data warehouse from the Volume chart:

  • Compare Loaded Rows with Processed Rows. If loaded rows are much higher than processed rows, the queue age will be increased.
  • Compare Processed Rows with Average daily processed rows (last 30 days).
    • If the processed rows are more, it indicates new data flows.
    • If the processed rows are lower than the average value, it indicates less data flows in the system.
  • Compare Processed Rows with Estimated daily capacity (8 hour period) and Estimated daily capacity (24 hour period).
    • If the processed rows value is less than the estimated 8 hour value, the environment is in a very good status.
    • If it is between estimated 8 hours and estimated 24 hours, the environment performances will be gradated due to the warehouse activity but the environment will still be usable.
    • If it is reaching or crossing estimated 24 hours, the environment is not sized enough for the amount of data that is loaded. It is recommended to review your sizing.

The status report that is displayed in the older versions of TrueSight Capacity Optimization is now part of the Space Report details page.

Was this page helpful? Yes No Submitting... Thank you

Comments