Is it eligible to enable SQL Server snapshot isolation for MOSS 2007 databases? RRS feed

  • Question

  • Hi, we have Sharepoint 2007 databases having deadlocks and blockings all the time, I think due to some custom applications on it. We can not edit queries and stored procedures, SQL Server snapshot isolation can fix the locking issues, but I couldn't find info if Snapshot Isolation is eligible for Sharepoint. Any comments on this?


    Thursday, September 22, 2011 2:44 PM


  • Hi,


    It is not recommended to visit SharePoint databases directly. You can use SharePoint object model instead, which could avoid these issues in a certain extent.


    For your question, you can refer to this article.





    Pengyu Zhao

    • Marked as answer by Wayne Fan Thursday, September 29, 2011 6:50 AM
    Monday, September 26, 2011 7:59 AM