SAP Knowledge Base Article - Preview

2141215 - Queries on Data-Only-Lock (DOL) tables doing a Nested Loop Join (NLJ) may sometimes experience High Contention on buffer spinlock resulting in slowness of query or server. - ASE


  • Query involving Data-Only-Lock (DOL) tables
  • A Nested Loop Join (NLJ) strategy is chosen
  • Queries may experience High Contention on cache buffer spinlock, resulting in slowness of the query
  • Multiple sessions running similar queries may result in an overall system slowness



SAP Adaptive Server Enterprise (ASE) 15.7


SAP Adaptive Server Enterprise 15.7


select, buffer spinlock contention, performance , KBA , optimizer , spinlock contention , 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.