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,