SAP Knowledge Base Article - Preview

2124770 - Slow performance experienced in Threaded mode on a SPARC Solaris system. - SAP ASE

Symptom

  • Queries doing a table scan when an index exists on the table
  • Outdated statistics
  • High spinlock contention
  • Sp_sysmons shows very high I/O usage

 Engine Utilization (Tick %)   User Busy   System Busy    I/O Busy        Idle
 -------------------------         ------------  ------------       ----------  ----------
 ThreadPool : syb_default_pool
  Engine 0                              9.6 %         0.5 %           89.9 %       0.0 %
  Engine 1                              7.8 %         0.6 %           91.6 %       0.0 %
  Engine 2                            10.4 %         0.5 %           89.1 %       0.0 %
  Engine 3                            12.8 %         0.6 %           86.6 %       0.0 %
  Engine 4                              8.8 %         0.4 %           90.8 %       0.0 %
  Engine 5                            13.0 %         0.6 %           86.4 %       0.0 %


 Average Runnable Tasks            1 min         5 min      15 min  % of total
 -------------------------  ------------  ------------  ----------  ----------
 ThreadPool : syb_default_pool
  Global Queue                   0.0           0.0         0.0       0.0 %
  Engine 0                           0.1           0.1         0.1       1.5 %
  Engine 1                           0.2           0.1         0.1       1.7 %
  Engine 2                           0.2           0.2         0.1       1.7 %
  Engine 3                           0.1           0.1         0.1       0.7 %
  Engine 4                           0.1           0.1         0.1       0.8 %
  Engine 5                           0.2           0.1         0.1       1.7 %


CPU Yields by Engine            per sec      per xact       count  % of total
-------------------------  ------------  ------------  ----------  ----------
ThreadPool : syb_default_pool
 Engine 0
    Full Sleeps                       28.8           0.0        8632       1.4 %
    Interrupted Sleeps              0.7           0.0         219       0.0 %
 Engine 1
    Full Sleeps                       29.3           0.0        8800       1.4 %
    Interrupted Sleeps              0.8           0.0         240       0.0 %
 Engine 2
    Full Sleeps                       28.1           0.0        8418       1.4 %
    Interrupted Sleeps              0.7           0.0         197       0.0 %
 Engine 3
    Full Sleeps                       27.5           0.0        8246       1.3 %
    Interrupted Sleeps              0.7           0.0         204       0.0 %
 Engine 4
    Full Sleeps                       28.3           0.0        8501       1.4 %
    Interrupted Sleeps              0.7           0.0         211       0.0 %
 Engine 5
    Full Sleeps                       28.2           0.0        8474       1.4 %
    Interrupted Sleeps              0.8           0.0         239       0.0 %


Thread Utilization (OS %)     User Busy   System Busy        Idle
-------------------------  ------------  ------------  ----------
ThreadPool : syb_blocking_pool : no activity during sample

ThreadPool : syb_default_pool
 Thread 13   (Engine 0)          10.9 %         0.7 %      88.5 %
 Thread 14   (Engine 1)            9.3 %         0.5 %      90.3 %
 Thread 15   (Engine 2)          11.6 %         0.6 %      87.8 %
 Thread 16   (Engine 3)          14.2 %         0.8 %      85.1 %
 Thread 17   (Engine 4)          10.4 %         0.5 %      89.1 %
 Thread 18   (Engine 5)          14.7 %         0.8 %      84.5 %


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 on Sun Sparc and threaded mode Only

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.