2586495 - sp_sysmon reports high values for Fully Logged APL Heap Table even when allpages locking is not in use -SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2586495 - sp_sysmon reports high values for Fully Logged APL Heap Table even when allpages locking is not in use -SAP ASE

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

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

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 ONE Support launchpad (Login required).

Search for additional results

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