How To Verify And Turn On Snapshot Isolation (READ_COMMITTED_SNAPSHOT) For A Project Management or Methodology Management SQL Server 2005 Database
(Doc ID 904454.1)
Last updated on NOVEMBER 05, 2018
Applies to:Primavera P6 Professional Project Management - Version 5.0 SP4 C/S and later
Primavera P6 Enterprise Project Portfolio Management - Version 5.0 SP4 C/S and later
Implementing Snapshot Isolation on a SQL Server 2005 Project Management or Methodology Management database has the potential to eliminate data contention and reduce deadlocks, lock contentions, and session waits. The instruction in this document will help verify that Snapshot Isolation is set for each database, and turn it on if it is not.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document