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
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.
SAP Knowledge Base Article - Preview