SAP Knowledge Base Article - Preview

1863319 - sp_sysmon reports higher I/O Busy after upgrade to version 15.7 - SAP ASE

Symptom

  • sp_sysmon reports higher "I/O Busy" after upgrade to ASE 15.7, for example:

Kernel Utilization
----------------------
 
Engine Utilization (Tick %)   User Busy   System Busy    I/O Busy        Idle
--------- --------------------------  --------------   -----------------   ------------         -----
ThreadPool : syb_default_pool                                                 
  Engine 0                                   0.0 %         0.0 %      93.0 %       7.0 %
  Engine 1                                   1.0 %         0.0 %      92.0 %       7.0 %
  Engine 2                                   3.0 %         1.5 %      89.0 %       6.5 %
  Engine 3                                   7.0 %         2.5 %      86.0 %       4.5 %
  Engine 4                                   0.0 %         0.0 %      93.5 %       6.5 %
  Engine 5                                   0.0 %         0.0 %      94.0 %       6.0 %

Pool Summary    Total              11.0 %         4.0 %     547.5 %     37.5 %
                       Average               1.8 %         0.7 %       91.3 %       6.3 %
Server Summary Total               11.0 %         4.0 %      547.5 %    37.5 %
                       Average                 1.8 %         0.7 %        91.3 %      6.3 %

  • Engine 0 and 5 is 93.0 %, 94.0 % "IO Busy" but have 0 "Max Outstanding I/Os":

Disk I/O Management
-----------------------------
 
Max Outstanding I/Os            per sec      per xact       count  % of total
-----------------------------           -----------     ------------      ---------  -----------
    Server                              n/a           n/a         171       n/a
    Engine 0                          n/a           n/a           0         n/a
    Engine 1                          n/a           n/a         112       n/a
    Engine 2                          n/a           n/a         111       n/a
    Engine 3                          n/a           n/a         171       n/a
    Engine 4                          n/a           n/a          96        n/a
    Engine 5                          n/a           n/a           0         n/a
 
I/Os Delayed by
    Disk I/O Structures               n/a           n/a            0       n/a
    Server Config Limit               n/a           n/a            0       n/a
    Engine Config Limit               n/a           n/a           0       n/a
    Operating System Limit         n/a           n/a           0       n/a

  • ASE is running in threaded kernel mode.


Read more...

Environment

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

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

CR757246, CR#757246, 757246,  monThread, ticks, monDeviceIO, monIOQueue, DiskController , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Bug Filed

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.