SAP Knowledge Base Article - Preview

2560901 - How to disable page level locking on a table in SQL Server database

Symptom

  • You would like to disable page locking on a table to improve concurency
  • You would like to avoid deadlocks on data pages


Read more...

Environment

  • Netweaver running SQL Server - all supported version.

Product

SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5

Keywords

poor performance, insert , slow, update, locks, concurency,deadlock , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem

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.