In TSCO, what is the process to fully refresh the TSCO database table statistics?

Version 1
    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 11.x, 10.x



    QUESTION:

    By default the table statistics are locked for all of the TSCO database schema tables.  This is because the table statistics (which are used by the Optimizer to pick the best SQL Execution Plan) are maintained by the TSCO Database Space Manager system task.

    But there are scenarios where it is a good idea to force a refresh of the TSCO table statistics.  This is particularly true:
      (A) After the deployment of several ETLs in a new TSCO envirnoment where the tables have gone from empty to containing data
      (B) If there is a query performance problem accessing TSCO performance data and the 'Analyze Schema' hasn't been run in at least 3 months.


    ANSWER:

    Here is the process to run the 'Database Space Manager' in Analyze Schema mode:

    (1) Under Administration -> ETL & System Tasks -> System Tasks, open the 'Database Space Manager' system task.

    User-added image

    (2) Click the 'Add run configuration' button.

    User-added image

    (3) Click the 'Advanced' button.

    User-added image
    (4) In the 'Name' field enter 'Analyze Schema'.

    User-added image

    (5) Under the 'Db Manager' tab change the 'Analyze mode' from 'Auto' to 'Analyze schema'.

    User-added image

    (6) Click the 'Save' button.

    User-added image

    (7) Click the 'run this configuration' button on the same line as the 'Analyze Schema' run configuration within the 'Run configurations' section of the screen.

    User-added image


    Article Number:

    000135453


    Article Type:

    FAQ/Procedural



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