Informix

nested-group-icon.png

DB2

Expand all | Collapse all

CPU Utilization and Performance Tuning

  • 1.  CPU Utilization and Performance Tuning

    Posted Thu December 17, 2020 11:46 PM

    Dears,

     Please let me know what steps should be taken in case of CPU Utilization high and Performance Tuning Scenarios.

    As few Steps I know , please correct or add your opinions.

    Performance Issue :

    Check for Index Field on Table based on SQL Running

    Check for Last Update Statistics

    Check for Long Running Query

    Check for Foreground writes onstat - F (if chunk write more , add more Buffer)

    Check for Read/Write cache - if below 85% then increase Buffers

    Check for Checkpoint .. if Occurring fast then increase values of LRU MIN/MAX

    Please let what other can I check and what also need to check for CPU Utilization high.

    Thanks

    Amit

     

     



    ------------------------------
    AMIT PATEL
    ------------------------------



  • 2.  RE: CPU Utilization and Performance Tuning

    Posted Thu December 17, 2020 11:54 PM
    Look at the query plans for long running queries especially when the IO is hig

    Cheers
    Paul

    Paul Watson
    Oninit LLC
    +1-913-387-7529
    www.oninit.com
    Oninit®️ is a registered trademark of Oninit LLC





  • 3.  RE: CPU Utilization and Performance Tuning

    Posted Fri December 18, 2020 06:02 AM

    Also:

    • Check my Bufwaits Ratio metric
    • Check my Buffer Turnover Rate #3 metric
    • Check my Lock Wait Ratio metric
    • Check my Sequential Scan Ratio metric

    All of these calculations are reported by the new_ratios.ksh script and accompanying stored procedure contained in my ratios.shr_ak package which you can download from the IIUG Software Repository (IIUG Software Repository).



    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------