locked
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?

    Thanks.

    Thursday, September 22, 2011 2:44 PM

Answers

  • 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.

     

    http://support.microsoft.com/kb/929649

     

    Thanks,

    Pengyu Zhao

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