SAP Knowledge Base Article - Preview

2456551 - High threads/engine CPU usage and Spinlock contention - SAP ASE

Symptom

  •  There is high engine thread utilization as per this sysmon output

                            

                      Capture7.PNG

  •     The first consideration would be to check for spinlock contention in the sp_sysmon output as shown here in the  default data cache subsection under Data Cache Management.

                       Capture1.PNG

  • The next consideration is to try and partition the cache with sp_cacheconfig to create more spinlocks. Look up the cache configuration with sp_cacheconfig.
  • But default data cache is already partitioned 16 ways and there are only 16 engines according to the output of sp_helpthread. It is not useful to have more spinlocks/partitions than engines.

                 Capture2.PNG

  • There is also no spinlock contention showing up in the Metadata Cache section.

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)
  • SAP Adaptive Server Enterprise Cluster Edition (ASE CE)

Product

SAP Adaptive Server Enterprise all versions

Keywords

high CPU, high kernel utilization,  Engine Utilization,  spinlock contention, system hung, ASE hangs, performance, slow , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.