Post reply

Does anyone using snapshot isolation for Sharepoint 2007 databases?

  • September 22, 2011 at 8:40 am

    #257661

    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, snapshot isolation can fix the locking issues, but I couldn't find info if SI is eligible for Sharepoint. Any comments on this?

    Thanks.

  • September 22, 2011 at 8:45 am

    #1385209

    It isn't something I would do lightly or without appropriate testing as you may invalidate licensing??? I would check with the Sharepoint Team maybe post something on their forums.

    Thanks

    Chris

    ------------------------
    I am the master of my fate:
    I am the captain of my soul.
    ------------------------
    Blog: http://sqlserver365.blogspot.co.uk/
    Twitter: @ckwmcgowan
    ------------------------

  • September 22, 2011 at 11:17 am

    #1385335

    Any more ideas?

  • September 22, 2011 at 11:35 am

    #1385347

    I'm guessing this is related to search crawls?

    I opened a very expensive ticket with MS on the issue and tried to make them fix this issue.

    They won.

    They have retry logic. You have to ignore the deadlocks because they won't let you fix their junk.

    We set up a seperate monitoring pool for the instances we installed SP on that ignores those things and some of our other policy based management policies.

    I didn't like it one bit, but that's what we ended up doing.

    ~Cheers!

    Craig Outcalt


    Tips for new DBAs: http://www.sqlservercentral.com/articles/Career/64632
    My other articles: http://www.sqlservercentral.com/Authors/Articles/Craig_Outcalt/560258

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply