Share:|

BMC Capacity Optimization provides a great many useful features. I think it would be helpful if we provided some daily checks that you could do to make sure everything is working. This month we'll look at a great way to make sure everything is A-OK!

 

  1. Check Administration > System > Status
    • Check for the alert messages on top of the page
      • with the button on the right you can drill down into details
    • Verify all enabled components are in green, and their "last update date" is current
    • If these are red, check the system task "component status checker" logs for errors


 

 

2. Check Database space on Administration >DATA WAREHOUSE > Status

    • Verify estimated days to crash is reasonably far (>10days),
      • If it's low, verify that autoextensible is set to YES
      • If the above conditions are not verified, check DB space with your DBA
    • The "System Data Tables" at the bottom, shows the most consuming DB tables

 

 

3. Check Administration >DATA WAREHOUSE > Data flow report

    • Verify the benchmark is not RED (you might have a problem of DB sizing)
    • Check the values in the "Processing rows" are near to "Loaded daily (last 30 day average)",
      • Check there are no big holes or spikes in the values inside the "Processing rows" column for the past days
      • The current day number of samples is normally lower, since the entire day has not passed
      • Gaps might mean a problem with ETLs loading data, or the data warehousing engine
      • Spikes might be the consequence of a previous hole, or of a data manual recovery activity

 

 

  1. Check the Data Warehouse queues

(Administration > DATA HUB > Status > Core Services - Near-real-time Warehouse service on BCO <=9.0)

(Administration > COMPONENTS > Backend Services > Core Services - Near-real-time Warehouse service on BCO >=9.5)

    • Verify the "max queue age" column values are under 24 hours
    • Verify there are no yellow or red lines, that could mean data warehouse is slow or hung

 

 

5. Check scheduled tasks execution

(Administration > SCHEDULER > System tasks on BCO <=9.0)
(Administration > ETL & SYSTEM TASKS > System tasks on BCO >=9.5)

    • Verify the "Maintenance activity chain" is scheduled (WAITING) and green (did not have execution errors)
    • Verify the Component Status checker is scheduled (WAITING) or RUNNING, and green/blue (did not have execution errors)
    • Verify other scheduled tasks are not in ERROR, in case verify their logs, or execution history)

 

 

6. Check running tasks

(Administration > SCHEDULER > System tasks on BCO <=9.0)

(Administration > ETL & SYSTEM TASKS > System tasks on BCO >=9.5)

    • Verify the RUNNING tasks are running for a reasonable time (<24 hours)
    • Verify "Last Exit" are not in ERROR/WARNING, in case verify their logs, or execution history

 

 

  1. Check scheduled ETLs execution

(Administration > SCHEDULER > ETL tasks on BCO <=9.0)

(Administration > ETL & SYSTEM TASKS > ETL tasks on BCO >=9.5)

    • Verify your production ETLS are scheduled (WAITING) and "Last Exit" is green (did not have execution errors), in case verify their logs, or execution history

 

 

  1. Check running ETLs

(Administration > SCHEDULER > ETL tasks on BCO <=9.0)

(Administration > ETL & SYSTEM TASKS > ETL tasks on BCO >=9.5)

    • Verify the RUNNING ETLs are running for a reasonable time (<24 hours)
    • Verify "Last Exit" are not in ERROR/WARNING, in case verify their logs, or execution history

 

 

9. Check data availability with a quick analysis over a sample system on the Workspace

    • Check the "Last activity" dates to be current or yesterday
    • Press the "Quick analysis" button on the right to chart one metric (i.e. CPU_UTIL)

 

 

10. Here is an example of a Quick Analysis chart with data

 

 

I hope you will find this procedure useful. This Knowledge Base article is available as How to quickly assess the health of a BCO installation - Daily checks over a Bco installation at:

https://bmcsites.force.com/casemgmt/sc_KnowledgeArticle?sfdcid=000099751

 

As always, your comments are appreciated and let me know if there is something you would like to see in an upcoming Pulse.

Have you missed a Pulse or more? Get back on track at BMC TrueSight Support Blogs

Thx, timo