locked
Urgent : proc_MatchSchedSubscriptions blocking SQL process (and so SharePoint 2007). Event log is managed by this procedure and contains millions of entries RRS feed

  • Question

  • Hello,

    We have an intranet platform with 8000 users on SharePoint 2007.

    We currently have issues every day around 9am or 8:30am : The intranet is not responding (white page loading during minutes) until we kill a process in SQL that is blocking every other process.

    The process that is blocking other calls a procedure called : "proc_MatchSchedSubscriptions"

    This procedure manage 3 tables :

    SchedSubscriptions

    EventLog

    EventSubsMatches

    We notice that the Table EventLog has 1.3M entries after 4 days (this table is cleaned every weeks right ?).

    This is a really an issue because if we don't kill the process, the intranet won't work at all. We have to do that almost every morning.

    Thanks you by advance,


    Jeff ANGAMA. Sharepoint Consultant Blog : Jeff Sharepoint Note Blog
    Twitter : Follow me on Twitter

    Thursday, November 21, 2013 10:40 AM

All replies

  • Assuming that you are on the latest SharePoint patch level, I would recommend opening a ticket with Microsoft. Any edits to the SQL databases will result in your environment being in an unsupported state.

    Dimitri Ayrapetov (MCSE: SharePoint)

    Friday, January 3, 2014 12:33 AM
  • Hey Jeff,

    Did you get a resolution for this?  Getting hit by it now.  From your post it seems safe to kill this process.  Did you run into any issues with killing it?

    Friday, June 26, 2015 7:11 PM
  • Hello

    Even purging some event we had the issues

    We killed the process every time it happened.

    We migrated to SP2013 and no more issues :s

    Best regards


    Jeff ANGAMA. Sharepoint Consultant Blog : Jeff Sharepoint Note Blog
    Twitter : Follow me on Twitter

    Sunday, June 28, 2015 3:19 PM