SAP Knowledge Base Article - Preview

2584359 - Heavy blocking and performance issue - ASE

Symptom

  • Heavy Blocking reported by application
  • There is a number percentage of Large I/Os denied because of pages in another buffer pool
  • sp_sysmon reports:

Large I/Os Denied due to                                                 
        Pool < Prefetch Size        348.5           0.1       20912       3.2 %
        Pages Requested                                                         
        Reside in Another                                                       
        Buffer Pool                  7464.9           2.4      447893      68.0 %


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.5

Product

Sybase Adaptive Server Enterprise 15.5

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

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.