SAP Knowledge Base Article - Preview

3663007 - Enabling READ_COMMITTED_SNAPSHOT and ALLOW_SNAPSHOT_ISOLATION parameters in Microsoft SQL Server on SAP Business One databases

Symptom

Customer considers enabling both READ_COMMITTED_SNAPSHOT and ALLOW_SNAPSHOT_ISOLATION parameters in Microsoft SQL Server to reduce the blocking on database level and improve performance of SAP Business One application.
Alternatively, customer would like to enable only the ALLOW_SNAPSHOT_ISOLATION parameter so that the SNAPSHOT isolation level can be used by third-party applications.


Read more...

Environment

  • SAP Business One
  • Microsoft SQL Server

Product

SAP Business One all versions

Keywords

READ_COMMITTED_SNAPSHOT, ALLOW_SNAPSHOT_ISOLATION, snapshot isolation, MSSQL, RCSI, performance, lock, blocking, deadlock, optimistic concurrency model , KBA , SBO-BC-PER , Performance , SBO-BC-DB-SQL , Microsoft SQL Server , 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.