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

• 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

SAP Adaptive Server Enterprise (ASE) 15.7

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