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 for Me (Login required).

    Search for additional results

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