2479028 - High CPU utilization & spinlock reported on syscolumns - ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2479028 - High CPU utilization & spinlock reported on syscolumns - ASE

Symptom

  • Stored Procedures are executed from a front end application with execute immediate
  • sp_sysmon show high cpu usage

  Engine Utilization (Tick %)   User Busy   System Busy    I/O Busy        Idle
  -------------------------  ------------  ------------  ----------  ----------
  ThreadPool : syb_default_pool                                                
   Engine 0                        98.9 %         0.0 %       0.2 %       0.9 %
   Engine 1                        99.0 %         0.0 %       0.2 %       0.8 %
   Engine 2                        98.5 %         0.0 %       0.3 %       1.2 %
   Engine 3                        99.5 %         0.0 %       0.2 %       0.3 %
   Engine 4                        98.4 %         0.0 %       0.3 %       1.2 %
   Engine 5                        99.4 %         0.0 %       0.2 %       0.4 %
   Engine 6                        99.3 %         0.0 %       0.2 %       0.6 %
   Engine 7                        99.2 %         0.1 %       0.2 %       0.5 %
  -------------------------  ------------  ------------  ----------  ----------
  Pool Summary        Total       792.2 %         0.1 %       1.7 %       6.0 %
                    Average        99.0 %         0.0 %       0.2 %       0.7 %

  • Dedicated cache bound to syscolumns shows high spinlock contention

Cache: <database>_syscolumns
                                  per sec      per xact       count  % of total
  -------------------------  ------------  ------------  ----------  ----------
    Spinlock Contention               n/a           n/a         n/a      55.8 %
 
    Utilization                       n/a           n/a         n/a      78.2 %
 
    Cache Searches
      Cache Hits                  11414.5         181.5     1369739     100.0 %
         Found in Wash                0.0           0.0           0       0.0 %
      Cache Misses                    0.0           0.0           0       0.0 %
  -------------------------  ------------  ------------  ----------
    Total Cache Searches          11414.5         181.5     1369739


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7

Product

SAP Adaptive Server Enterprise 15.7

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement

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.