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.