SAP Knowledge Base Article - Preview

2065452 - sp_sysmon is showing User Busy for the ThreadPool : syb_default_pool as values far greater than 100% - ASE

Symptom

Sysmon showing very high values for the threadpool, a portion of the sysmon follows:


  Thread Utilization (OS %)     User Busy   System Busy        Idle
  -------------------------  ------------  ------------  ----------
  ThreadPool : syb_blocking_pool
   Thread 52   (Work Queue Task)    0.4 %         0.6 %      99.0 %
   Thread 53   (Work Queue Task)    0.4 %         0.7 %      98.9 %
   Thread 54   (Work Queue Task)    0.4 %         0.7 %      99.0 %
   Thread 55   (Work Queue Task)    0.3 %         0.6 %      99.1 %
  -------------------------  ------------  ------------  ----------
  Pool Summary      Total           1.5 %         2.6 %     395.9 %
                  Average           0.4 %         0.6 %      99.0 %

  ThreadPool : syb_default_pool
   Thread 2    (Engine 0)          7376 %       198.0 %       0.0 %
   Thread 3    (Engine 1)          8809 %       203.9 %       0.0 %
   Thread 4    (Engine 2)          9394 %       200.4 %       0.0 %
   Thread 5    (Engine 3)          8947 %       235.1 %       0.0 %
   Thread 6    (Engine 4)          8575 %       185.1 %       0.0 %
   Thread 7    (Engine 5)          9476 %       209.1 %       0.0 %
   Thread 8    (Engine 6)          9166 %       203.6 %       0.0 %
   Thread 9    (Engine 7)          8958 %       227.0 %       0.0 %
   Thread 10   (Engine 8)          8974 %       185.9 %       0.0 %
   Thread 11   (Engine 9)          9900 %       217.9 %       0.0 %
   Thread 12   (Engine 10)         9421 %       204.5 %       0.0 %
   Thread 13   (Engine 11)         9261 %       225.9 %       0.0 %
   Thread 14   (Engine 12)         9688 %       199.3 %       0.0 %


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) , 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.