Symptom
What is the difference between Full Sleep and Interrupted Sleep in the sp_sysmon section 'CPU Yields by Engine'?
CPU Yields by Engine per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
ThreadPool : syb_default_pool
Engine 0
Full Sleeps 22.1 156.2 2655 24.0 %
Interrupted Sleeps 0.4 3.1 53 0.5 %
Engine 1
Full Sleeps 22.2 156.9 2668 24.2 %
Interrupted Sleeps 0.3 2.3 39 0.4 %
Engine 2
Full Sleeps 22.2 156.9 2667 24.2 %
Interrupted Sleeps 0.0 0.1 2 0.0 %
Engine 3
Full Sleeps 24.3 171.6 2918 26.4 %
Interrupted Sleeps 0.3 2.3 39 0.4 %
------------------------- ------------ ------------ ----------
Pool Summary 92.0 649.5 11041
------------------------- ------------ ------------ ----------
Total CPU Yields 92.0 649.5 11041
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0
Product
Keywords
threaded, process, mode, interval, runnable, yeld , 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.
SAP Knowledge Base Article - Preview