SAP Knowledge Base Article - Preview

3452946 - Enabling ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT options in SQL server - SAP PD

Symptom

  • The Troubleshooting the Repository Installed on SQL Server chapter of the installation guide indicates:
    To ensure that all users reading data will get access to a snapshot and not be blocked by concurrent transactions, we recommend that you enable the following SQL Server options:
    • ALLOW_SNAPSHOT_ISOLATION
    • READ_COMMITTED_SNAPSHOT
    • What are the SQL statements to enable ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT parameters in SQL Server?


    Read more...

    Environment

    • SAP PowerDesigner 16.7 SP03
    • Microsoft SQL Server

    Keywords

    performance, isolation, level, locking, blocking , KBA , BC-SYB-PD , PowerDesigner , 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.