SAP Knowledge Base Article - Preview

3198635 - High CPU and SQL lock due to auto_update_statistics - Netweaver

Symptom

  • averaging 100% CPU usage
  • SQL lock waits
  • sql_updatestat_per_systemtable
  • Feature auto_update_statistics is on


Read more...

Environment

NetWeaver on MaxDB database

Product

SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

Keywords

CPU,SQL lock waits,sql_updatestat_per_systemtable,auto_update_statistics , KBA , BC-DB-SDB , MaxDB , Problem

About this page

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

Search for additional results

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