Skip to main content
Share Your Experience: Take the 2024 Developer Survey
22 votes
Accepted

How does Sitecore know an event in the event queue table has been processed?

In order to know which if the events have already been processed, you will need to check the Properties table. Using Sitecore OOTB You need to see the http://[domain]/sitecore/admin/EventQueueStats....
Hishaam Namooya's user avatar
20 votes
Accepted

Why is event data stored in every Sitecore database?

I believe the primary reason is each event has an associated target database. Found a brief explanation here by Kiran Patils on how the event queuing works: The CM instance triggers an event such as ...
Michael West's user avatar
  • 18.2k
13 votes

Does Sitecore have a message queue?

In Sitecore 9.x There is a new message bus implementation based on Rebus with an RabitMQ Transport Provider. This can be leveraged for your own custom requirements too. It is used already in Sitecore ...
Adam Seabridge's user avatar
9 votes
Accepted

How to raise an event in Sitecore 9+

In Sitecore 9 the event model has changed somewhat and events are now queued within each DB (master, core, web etc). This is partially correct. You could always queue remote events in your Sitecore ...
jrap's user avatar
  • 4,951
8 votes

Why is event data stored in every Sitecore database?

Answer All databases have an [EventQueue] in order to help spread out responsibilities and reduce the load on a particular database. Explanation The [EventQueue] table exists as a means of ...
jrap's user avatar
  • 4,951
7 votes
Accepted

When is it safe to remove an `EventQueue` record?

After having processed an event from the queue each instance updates the associated last processing timestamp (LPT) which is stored in the Properties table and has the key in the following format '...
Alexander Mogilka's user avatar
7 votes
Accepted

Can a server subscribe to its own remote events?

The event queue table has two columns related to the matter. They are RaiseGlobally (true by default) and RaiseLocally (false by default). These flags control the event execution appropriately (i.e. ...
Andrey Bobrov's user avatar
6 votes

Effective way to resolve the EventQueue, CPU and memory load related issue

You can usually improve this by tuning the settings for our queues. A good post in this can be found here: https://briancaos.wordpress.com/2016/08/12/sitecore-event-queue-how-to-clean-it-and-why/ ...
Gatogordo's user avatar
  • 20.1k
6 votes

Event Queue Created Field (time stamp)

I found out that field is populated with UTC regardless of what the server time zone is.
MikeD's user avatar
  • 870
6 votes

When is it safe to remove an `EventQueue` record?

In order to be 100% sure that a particular event was processed by all servers, you would need to write a rather complex query. To illustrate, I've written a query to return all events processed by a ...
jrap's user avatar
  • 4,951
6 votes
Accepted

Does Sitecore have a message queue?

Not out of the box. You could theoretically craft something on top of the EventQueue, but I would probably look to third party solutions. https://particular.net/nservicebus https://azure.microsoft....
Mark Cassidy's user avatar
  • 25.3k
5 votes

How does Sitecore know an event in the event queue table has been processed?

Expanding from the above answer you can try the below SQL Query to know the Number of Records to be processed from a given time and date: SELECT COUNT(*) FROM EventQueue WITH (NOLOCK) WHERE (...
Sumit Upadhyay's user avatar
4 votes

Error while accessing EventQueueStats.aspx

It looks like there is a bug in Sitecore 9.3. It tries to get a method using reflection on interface IEventQueue instead of on EventQueue abstract class, like it was in earlier version. You can either ...
Marek Musielak's user avatar
  • 23.8k
4 votes

How Sitecore 9.02 event queue agent configuration properties impact the event queue cleanup activity

Your understanding is correct, DaysToKeep parameter is used only if IntervalToKeep is not specified. The interval parameter tells Sitecore how often the CleanupEventQueue agent should wake up to check ...
Anna Gevel's user avatar
  • 1,953
3 votes

DTU shooting up after application start in Azure PAAS Sitecore 9.0.2

I was suffering from a similar issue for the SQL server for different databases. Below are the details. Cloud Environment: Sitecore Managed Cloud XP-Small and XP-Medium Sitecore Version: Sitecore 9....
Nikhil Kulkarni's user avatar
3 votes

How to raise an event in Sitecore 9+

Can't say I've had to do this, but firing up my friend ILSpy, I've got a few ideas for you: You can open Sitecore.Kernel and find IEventQueue and "analyze" the QueueEvent() method to find places it's ...
JermDavis's user avatar
  • 847
3 votes

When is it safe to remove an `EventQueue` record?

For reference there is a nice response on StackOverflow as to how cleanup the queue. Sitecore recommends fewer than 1000 items in the table and the solution to keep them below that is to run the ...
Michael West's user avatar
  • 18.2k
3 votes
Accepted

Index Update Strategy not Firing on Publish End with Custom Publishing Target and Custom Solr Index

The solution mentioned in Dan Sinclair's comment worked to fix this issue. Thanks Dan! DELETE FROM [Core].[dbo].[Properties] WHERE [Key] LIKE '%_LAST_UPDATED_TIMESTAMP%' After running this operation ...
Alex's user avatar
  • 545
3 votes

How to know if Remote Events has been executed on remote environments?

Technically you could run a custom SQL query to see if a server completed execution of a Remote Event, but I wouldn't recommend it. When you say: Is there anyway i can get notified except watching ...
jrap's user avatar
  • 4,951
2 votes

Effective way to resolve the EventQueue, CPU and memory load related issue

You can optimize memory usage by enabling Sitecore Interning. To do this enable this two settings: <setting name="Interning.Enabled" value="false"/> <setting name="Interning....
Bartłomiej Mucha's user avatar
2 votes
Accepted

item:saving event has both new and old field values

item:saving event is executed before item is saved in the database. Item which is stored within event args is what will be saved to the database if none of the handlers abandons the process. And item ...
Marek Musielak's user avatar
  • 23.8k
1 vote

Error while accessing EventQueueStats.aspx

I'll add a little more context around why one might discover this error and recommend some followup tasks after the fix is implemented (the other answers definitely fix the error). In my case, I ...
Marcel Gruber's user avatar
1 vote
Accepted

Error while accessing EventQueueStats.aspx

As Marek suggested above, We reached out to Sitecore support for this issue and they confirmed that this is a bug in Sitecore 9.3. This bug has reference number 420812 and it was fixed in Sitecore 10. ...
Raman Gupta's user avatar
  • 2,559
1 vote
Accepted

Lucene indexing issue on CD servers with multiple DBs

Given the details in the above questions, the only thing I found missing, is the Lucene config for master index. I am also running a platform on Sitecore 8.2.2 with Lucene and in a setup similar to ...
Somnath Dutta's user avatar
1 vote

Avoid publishing queues / allow concurrent users to publish on Sitecore 8.1

Sitecore has released on 8.2 the publishing service which is not built into the product but it's a service that works really well for that. This is more as an FYI. But you said you are running on 8.1 ...
Diego's user avatar
  • 5,688
1 vote

Effective way to resolve the EventQueue, CPU and memory load related issue

That's true. you can use this option to clean event queue. If you are facing CPU or memory load issue or may be performance issue so its better to clean few more table as well apart from EventQueue: ...
Jitendra's user avatar
  • 1,038
1 vote

Sitecore parallel publishing locks up Content Delivery server

I think it's your big event queue. Try the following - Make sure your CD indexes indexing strategy is set to manual. This will prevent double indexing of the web content. Of course there may be ...
Gabbar's user avatar
  • 608
1 vote

Excessive updates of the EventQueue table

Every time an index update operation occurs, an index update timestamp is written to the Property table of the core database. This is a known issue related to this behavior. This happens because ...
Vlad Iobagiu's user avatar
  • 18.6k
1 vote
Accepted

Missing EventQueue entry from Properties table?

transpires that contrary to previous advise from sitecore support that you should be replicating the properties table, as otherwise the CM and CD servers have no knowledge of each others event queues. ...
David Buckell's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible