Home > database >  Copy the lock conflicts in the process of distribution
Copy the lock conflicts in the process of distribution

Time:09-21

Sql2012 version, the production of libraries and libraries in a machine, distribution of a library open first things, the library has opened ALLOW_SNAPSHOT_ISOLATION ON and READ_COMMITTED_SNAPSHOT ON, now no lock conflicts in the process of normal use, but tracking, found that ON the distribution of snapshot, there will be a lock conflict, and this setting is not set to for help? Check the MSDN mentioned concurrent snapshot won't produce lock, but found no place Settings,



  • Related