Article - CS315824
Enabling ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT in ThingWorx Platform databases for Microsoft SQL Server
Modified: 02-Jan-2025
Applies To
- ThingWorx Platform 8.1 to 9.7
- Microsoft SQL Server
- Azure SQL Server
Description
- Should Read Committed Snapshot be set to ON?
- Does Allow Snapshot Isolation need to be ON?
- Can deadlocks be reduced by setting ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT to ON?
- How to enable READ_COMMITTED_SNAPSHOT and ALLOW_SNAPSHOT_ISOLATION
- How to decrease deadlocks using Snapshot Isolation
- Large number of [1,002] Data store integrity violation error messages are observed when attempting to install ThingWorx Analytics to a MSSQL backed version of the ThingWorx Platform
This is a printer-friendly version of Article 315824 and may be out of date. For the latest version click CS315824