Does the Change Auditor database support Snapshot Isolation or Read Committed Snapshots? (225718)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Does the Change Auditor database support Snapshot Isolation or Read Committed Snapshots?
Description

Administrators may want to Snapshot Isolation or Read Committed Snapshots on the Change Auditor database in order to improve overall performance when running reports on databases with high writes.
Resolution

The Change Auditor database has not been tested with Snapshot Isolation and/or Read Committed Snapshots and, therefore, is currently not supported.
For Change Auditor events, rows are typically inserted but not later updated. Snapshot Isolation and/or Read Committed Snapshots primarily benefit applications which update the same row information from multiple connections. This scenario is not applicable for Change Auditor.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title