Blog Post

Azure Database Support Blog
2 MIN READ

Lesson Learned #486: Snapshot Isolation Transaction Failed Due to a Concurrent DDL Statement

Jose_Manuel_Jurado's avatar
Jose_Manuel_Jurado
Icon for Microsoft rankMicrosoft
May 14, 2024
Today, we worked on a service request that our customer faced the following error message: Msg 3961, Level 16, State 1, Line 4 Snapshot isolation transaction failed in database 'DbName' because the o...
Updated May 14, 2024
Version 2.0
azure sql database
snapshot isolation
Aniela's avatar
Aniela
Copper Contributor
Nov 18, 2025

Hey,

What if there is an index optimization running that does ONLINE rebuild when there are also queries coming from application with SI ON, trying to access same objects? 

Which is the best way of doing the index rebuild with minimal impact while having also queries running ?

 

Thanks.