2502761 - CPU Utilization and Logical Reads for some tables increased after upgarde to v.16.0 from v.15.7 - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2502761 - CPU Utilization and Logical Reads for some tables increased after upgarde to v.16.0 from v.15.7 - SAP ASE

Symptom

  • CPU Utilization increased by ~10%.
  • Logical Reads increased for some tables.
  • After upgrade from SAP ASE 15.7 to SAP ASE 16.0 SP02 PL04.
  • The optimizer level was changed from ‘ase_default’ in ASE 15.7 to ‘ase_current’ in ASE 16.0 SP02 PL04. 
  • Need a strategy for:
    • identifying missing stats
    • identifying outdated column level stats that are not part of indexes
    • updating column stats for large tables

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7

Keywords

datachange, stale, sensitive, column, indexes,  SARG, join, histogram, tuning, factor, steps , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.