SAP Knowledge Base Article - Preview

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

Symptom

  • 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 %


Read more...

Environment

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

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

User, System, Busy, alter, thread, performance , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.