How to quickly assess the health of TrueSight Capacity Optimization (TSCO) - Daily checks over a TSCO installation - INCLUDES VIDEO

Version 5
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    TrueSight Capacity Optimization


    COMPONENT:

    Capacity Optimization


    APPLIES TO:

    TrueSight Capacity Optimization 20.02, 11.5, 11.3.01, 11.0, 10.7, 10.5



    QUESTION:

    I am a TrueSight Capacity Optimization (TSCO) administrator.
    What I can do on daily basis to have a quick overview of the status of my TSCO?



     


    ANSWER:

     


    Check this video from the TrueSight Capacity Optimization Youtube channel:



    Additional Information:
    Refer https://docs.bmc.com/docs/display/btco115/Using+filtering+options+in+the+TrueSight+console documentation page for more information about the topic.  
    Have you seen TrueSight Server Automation How-To videos series? Refer them here.
    Click to subscribe "TrueSight Capacity Optimization", our dedicated YouTube channel for How-to videos of product – TrueSight Capacity Optimization (TSCO).
     

      

    1. Check system status

    Go on the page   Administration > System > Status

    TSCO 11.5 and later:

    TSCO 11.5.01 Status Page
    Clicking on the component box will drill down to the error message or the sub-component that is reporting the error: 

    Error drill down
    TSCO 11.3.01 and earlier:

    User-added image
    From here, you can check two things:
      
       
    1. In table Messages: with the button on the right you can drill down into details. For example, you can look at the failed ETLs, check each ETL log and understand if could be an environment problem (e.g. data source not reachable) or if you need to involve product support. In this second case, please attach ETL logs to case (How to gather BCO ETL logs)
    2.  
    3. in table Components that all enabled components are in green, and their last update date is updated (the check of the status of the components is performed every 10 minutes by the Component Status Checker task). If you don't see the status updated, check if this task is properly scheduled
      

    2. Check Database space and Warehouse status

      

    Go on the page Administration >Data Warehouse > Status
    User-added image

      
       
    1. In Alert box, check if there are alerts. If yes, drill down to understand details
    2.  
    3. In Space box, check if the database space is not real to saturation. If you click on Space report, you will have details for each table space. Verify estimated days to crash for each table space is reasonably far (for example, greater that 10 days)     
           
      • If it's low, verify that auto extensible is set to YES
      •    
      • If the above conditions are not verified, check DB space with your DBA
      •   
    4.  
    5. In Flow box, check if there are alerts. In details, you can check the maximum queue age. If it greater than 24 hours, get in contact with support, excluding some cases likes:     
           
      • There were problems in the infrastructure recently (e.g. a down of the DB)
      •    
      • There is a massive historical recovery in progress
      •   
    6.  
    7. In Volume box, check if the flow is stable and check if there is not negative peak. If you find one, check if all ETLs are running properly and check the Flow box (previous point)
      

    3. Check the Maintenance Tasks

    Go on page  Administration > ETL & SYSTEM TASKS > System tasks
    User-added image
      
       
    1. Verify that Maintenance Activity chain is scheduled (WAITING as Status) and last exit is OK (green)
    2.  
    3. Verify that Component Status Checker task is scheduled (WAITING or RUNNING as Status) and last exit is OK (green)
    4.  
    5. Verify other scheduled tasks are not in ERROR. If there are, verify their logs or execution history
    6.  
    7. Verify if there are RUNNING tasks and check if they have been running for a reasonable time (<24 hours)
      

    3. Check the ETL Tasks

      

    Go on page Administration > ETL & SYSTEM TASKS > ETL tasks

      
       
    1. Verify your production ETLs are scheduled (WAITING as Status) and last exit is OK (green). In case of ERROR or FAILED as last exit, verify their logs or execution history
    2.  
    3. Verify if there are RUNNING ETLs and check if they have been running for a reasonable time (<24 hours)
      

    4. Check on data

    Check data availability with a   Quick Analysis over a sample system on the   Workspace section 
    User-added image  
       
    • Check the Last activity dates to be current or yesterday
    •  
    • Press the Quick analysis button on the right to chart one metric (e.g. CPU_UTIL) and select a time filter like last 7 days. If the chart is not produced and you get the warning No data is available for the selected time filter, please go back in the previous page, click on the information icon (User-added image) on the raw of the metric you select for the analysis. Check:
      
       
    1. If the ETL that have to import this metrics is running properly
    2.  
    3. Check the status of the warehouse (see one of previous points) 
    For any clarification, you can get in contact with product support team, providing details of the problem, screenshots and logs. 
    You can collect:  
       
    1. ETL logs in case of ETL errors (KA 000032103: How to gather TSCO ETL logs)
    2.  
    3. Application logs in case of error in system tasks, analysis execution and other generic issues (KA 000099787: In TSCO, how do I gather the log files using log Grabber?)

     


    Article Number:

    000099751


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles