SAP Knowledge Base Article - Preview

2685897 - How are the number of threads in the syb_system_pool calculated by ASE

Symptom

  • Query master..monThread monitoring table.
       monThread..BusyTicks column will display accumulated values
       monThread..IdleTicks column will display single digit values or zero
       monThread..TaskRuns column will display single digit values or zero
  • sp_helpthread output between 2 ASE instances with identically configuration (cfg) file.

ASE Instance#1

Name              Type                 CurrentSize TargetSize IdleTimeout Description                                  InstanceName
----------------- -------------------- ----------- ---------- ----------- -------------------------------------------- ------------
syb_blocking_pool Run To Completion              4          4           0 A pool dedicated to executing blocking calls NULL
syb_default_pool  Engine (Multiplexed)           5          5         500 The default pool to run query sessions       NULL
syb_system_pool   Run To Completion              4          4           0 The I/O and system task pool                 NULL       <<<< HERE

ASE instance#2

Name              Type                 CurrentSize TargetSize IdleTimeout Description                                  InstanceName
----------------- -------------------- ----------- ---------- ----------- -------------------------------------------- ------------
syb_blocking_pool Run To Completion              4          4           0 A pool dedicated to executing blocking calls NULL
syb_default_pool  Engine (Multiplexed)           5          5         500 The default pool to run query sessions       NULL
syb_system_pool   Run To Completion              3          3           0 The I/O and system task pool                 NULL       <<<< HERE


Read more...

Environment

  • SAP Adaptive Server Enterprise 16.0
  • SAP Adaptive Server Enterrpise 15.7

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

threadpool, thread, pool, ctlib controller, monThread, RTC, run-to-completion , 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.