SAP Knowledge Base Article - Preview

2088842 - Differences between Full Sleep and Interrupted Sleep in the sp_sysmon section 'CPU Yields by Engine' - SAP ASE

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

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

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.