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