Page created: 11 Apr 2023 |
Page updated: 11 Apr 2023
Because deadlocks can occur in some tables in high-concurrency environments with contention for shared data, you can enable READ_COMMITTED_SNAPSHOT in SQL Server to improve the performance and scalability of applications with long-running transactions.
When snapshot isolation is enabled, each transaction reads data from a snapshot of the database taken at the start of the transaction rather than directly from the database itself.
Because there can be some overhead with snapshot isolation, evaluate and test this setting carefully before deploying in production environments. For more information on snapshot isolation and how to configure the option, see Snapshot Isolation in SQL Server in the Microsoft documentation.