I have a single CD CM 8.2 instance of sitecore.
We have a job that is running at a particular time everyday which publishes around a 1000 items. Our CD server crashes everytime the job runs and the query that blocks the website is:
)SELECT [EventType], [InstanceType], [InstanceData], [InstanceName], [UserName], [Stamp], [Created] FROM [EventQueue] WHERE ([InstanceName] <> @targetInstance AND [RaiseGlobally] = 1 OR [InstanceName] = @targetInstance AND [RaiseLocally] = 1) AND [Stamp] >= CAST(@fromTimestamp AS TIMESTAMP) ORDER BY [Stam
Our DB configuration is as follows:
- AWS RDS instance - db.m4.xlarge — 4 vCPU, 16 GiB RAM, 1000 IOPS
- CD server is 16 GB RAM
What would be the best way to resolve this issue?
Upgrade the IOPS of the server? Upgrade the RAM?