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

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,

November 21st, 2013 5:43am

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.
Free Windows Admin Tool Kit Click here and download it now
January 3rd, 2014 12:33am

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?

June 26th, 2015 3:11pm

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

Free Windows Admin Tool Kit Click here and download it now
June 28th, 2015 11:20am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics