We are using Sitecore 7.2 and Coveo for sitecore in our multilingual CMS website. Our sitecore really gets slow sometimes and we could also see deadlocks happening in our application logs.
Upon analysis, We could see that there are almost 300000 records getting added in our EventQueue table of Core database. Sitecore recommends to have less than 1000 rows in EventQueue table.
Current CleanupEventQueue task is set to Run every 4 hours to remove the entries which are older than a day and so EventQueue table does not contain any entries older than a day.
We found that Property changed event is getting triggered for every coveo index last updated field change and due to this,a large number of row entries are added to the EventQueue table. This constitutes to almost 60% of the rows in the EventQueue table.
EventType : Sitecore.Data.Eventing.Remote.PropertyChangedRemoteEvent, Sitecore.Kernel, Version=126.96.36.199, Culture=neutral, PublicKeyToken=null
We followed the sitecore recommendation based on the article https://kb.sitecore.net/articles/930920 and added the required configs and library files. Even after adding the recommendation, we could not see the count of EventQueue rows getting reduced.
Can you please let me know if I am missing something.