2588442 - sp_sysmon reports High User Busy across all engines - ASE

• The sp_sysmon reports high User Busy across all Engines in syb_default_pool

Engine Utilization (Tick %) User Busy System Busy I/O Busy Idle
------------------------- ------------ ------------ ---------- ----------
ThreadPool : syb_default_pool
Engine 0                         92.9 %         2.4 %     4.3 %     0.4 %
Engine 1                         93.3 %         2.7 %     3.7 %     0.3 %
Engine 2                         91.9 %         3.2 %     4.4 %     0.6 %
Engine 3                         91.7 %         3.7 %     4.3 %     0.4 %
Engine 4                         92.0 %         3.2 %     4.4 %     0.4 %
Engine 5                         92.4 %         3.2 %     4.2 %     0.3 %
Engine 6                         92.5 %         2.9 %     4.2 %     0.5 %
Engine 7                         92.1 %         2.9 %     4.4 %     0.6 %
------------------------- ------------ ------------ ---------- ----------
Pool Summary Total        738.7 %      24.0 %   33.8 %     3.4 %
Average                            92.3 %         3.0 %     4.2 %     0.4 %

• The thread utilization number shows higher CPU units compared to the number of engines

Adaptive Server threads are consuming 8.5 CPU units.
Throughput (committed xacts per CPU unit) : 287.9

• The Non-Voluntary Yields of syb_default_pool are greater compared to Voluntary Yields in Context Switches at OS.

Context Switches at OS per sec      per xact     count     % of total
-------------------------- ------------ ------------ ---------- ----------
ThreadPool : syb_blocking_pool
Voluntary                              0.0             0.0             0      0.0 %
Non-Voluntary                       0.0             0.0             0      0.0 %
ThreadPool : syb_default_pool
Voluntary                            43.1             0.0        7755      0.7 %
Non-Voluntary                   109.5             0.0      19709      1.8 %
ThreadPool : syb_system_pool
Voluntary                        5678.5             2.3   1022131    93.8 %
Non-Voluntary                   221.0             0.1       39779      3.7 %
------------------------- ------------  ------------  ----------  ----------
Total Context Switches      6052.1             2.5   1089374   100.0 %

• Adaptive Server Enterprise (ASE) 15.7
• Adaptive Server Enterprise (ASE) 16.0

User, System, Busy, alter, thread, performance, alter thread pool, syb_default_pool , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem