SAP Knowledge Base Article - Preview

3048136 - Total Priority Changes in sysmon reporting high counts in ASE 16.0 SP03 PL06 and higher - SAP ASE

Symptom

sp_sysmon is reporting high numbers for "Total Priority Changes" running the same reorg compact:

  • ASE 16.0 SP03 PL04
    Total Priority Changes 0.7 0.0 64
  • ASE 16.0 SP03 PL07
    Total Priority Changes 198.9 6.1 17900

*************************************************************

@@version Adaptive Server Enterprise/16.0 SP04 GA/EBF 29650
Application Statistics Summary (All Applications)
-------------------------------------------------
Priority Changes per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
To High Priority 115.2 3.1 10369 49.9 %
To Medium Priority 115.5 3.1 10396 50.0 %
To Low Priority 0.3 0.0 27 0.1 %
------------------------- ------------ ------------ ----------
Total Priority Changes 231.0 6.1 20792

@@version -- Adaptive Server Enterprise/16.0 SP03 PL04/EBF 27872

Application Statistics Summary (All Applications)
-------------------------------------------------
Priority Changes per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
To High Priority 0.0 0.0 0 0.0 %
To Medium Priority 0.2 0.0 15 50.0 %
To Low Priority 0.2 0.0 15 50.0 %
------------------------- ------------ ------------ ----------
Total Priority Changes 0.3 0.0 30


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL06 and higher

    Product

    SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 15.7 Cluster Edition ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise 16.0 Cluster Edition

    Keywords

    priority changes, sp_sysmon , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

    About this page

    This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

    Search for additional results

    Visit SAP Support Portal's SAP Notes and KBA Search.