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