Viewing the status of the data warehouse

The bar represents the total space of the filesystem used by the tablespace of the BMC Helix 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.

Displays values and charts for the following volumes processed by the BMC Helix 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.