Deadlock prevention
Used with default settings on MSSQL highly concurrent Planon sessions can lead to deadlocks. Planon recommends changing some settings on database level in order to decrease the chances of a deadlock situation. Apply the following statements to achieve the READ_COMMITTED_SNAPSHOT level of isolation:
ALTER DATABASE <DB Name> SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
ALTER DATABASE <DB Name> SET READ_COMMITTED_SNAPSHOT ON;
ALTER DATABASE <DB Name> SET MULTI_USER;
ALTER DATABASE <DB Name> SET READ_COMMITTED_SNAPSHOT ON;
ALTER DATABASE <DB Name> SET MULTI_USER;
Replace <DB Name> by the database name.
 | These statements should be executed by a DBA only. |
If these settings are not configured, the following warning will be logged in the serverboot.log file when starting the applicaiton server:
WARN [SystemBODefinitionCache] database property
READ_COMMITTED_SNAPSHOT is not ON! change your DB configuration!
READ_COMMITTED_SNAPSHOT is not ON! change your DB configuration!