Symptom
sp_sysmon reports elevated counts for Inserts under Fully logged APL Heap Table despite having the default lock scheme to datarows or datapages and no allpages locked tables are used in ASE.
In this example, we see large amounts of APL Heap Table inserts even though APL tables are not used by the application
Transaction Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Fully Logged
APL Heap Table 1434.4 0.3 430318 87.0 %
APL Clustered Table 0.0 0.0 0 0.0 %
Data Only Lock Table 214.2 0.0 64268 13.0 %
Fast Bulk Insert 0.0 0.0 0 0.0 %
Fast Log Bulk Insert 0.0 0.0 0 0.0 %
Minimally Logged
APL Heap Table 0.0 0.0 0 0.0 %
APL Clustered Table 0.0 0.0 0 0.0 %
Data Only Lock Table 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Inserted 1648.6 0.4 494586 81.3 %
Read more...
Environment
SAP Adaptive Server Enterprise (ASE)
Product
Keywords
CR812690, CR#812690, 812690, sp_sysmon, Fully Logged, APL Heap Table, allpages, datarows, datapages , 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.