Sample Header Ad - 728x90

What are the downsides of Accelerated Database Recovery, assuming that Read Committed Snapshot Isolation is enabled?

1 vote
1 answer
202 views
When I look over the documentation for Accelerated Database Recovery and Read Committed Snapshot Isolation, it appears that every downside of Accelerated Database Recovery is shared by Read Committed Snapshot Isolation. So assuming that I already have Read Committed Snapshot Isolation enabled, what are the downsides of Accelerated Database Recovery? I suspect that there is no coincidence that both Accelerated Database Recovery and Read Committed Snapshot Isolation are enabled by default in Azure. Assume either SQL Server 2019 or SQL Server 2022.
Asked by J. Mini (1237 rep)
Jan 15, 2025, 07:53 PM
Last activity: Jan 16, 2025, 11:38 AM