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
------------------------------

#Informix

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
------------------------------