Object Queue Performance Update

posted Dec 19, 2018, 10:27 AM by Greg Kent   [ updated Dec 19, 2018, 12:25 PM ]
ObjectQueue has been updated to address performance issues. The following objects have been updated:
  • dbo.ObjectQueue - Specialized indexes for CurrentQueue and CallbackQueue usage
  • ObjectQueue/PopItem - Optimized to reduce/eliminate deadlocks
 ObjectQueue contention was causing deadlocks for:
  • Callback processing
  • CurrentQueue processing
which resulted in stalled workflows and overall database contention.

Please ensure the above updates are deployed together to avoid any performance issues.