U0003525 ===> 'SELECT TOP 1 * FROM MQDWP with (ROWLOCK, READPAST, UPDLOCK) WHERE MQDWP_SchedTime<=?

Document ID : KB000089048
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
U0003525 ===> 'SELECT TOP 1 * FROM MQDWP with (ROWLOCK, READPAST, UPDLOCK) WHERE MQDWP_SchedTime
Resolution:

Investigation
These are obviously time critical Database calls that are showing up on the MQ tables.  The MQ tables stand for "Message Queue" and are basically a workspace that Automic uses to prepare messages and work for the system.  Perhaps the system has recently had some other problems that were corrected with back-end SQL statements or some other correction.

Solution
This issue is usually solved by clearing out the MQ tables of all messages.  A message that has not gone through these tables completely will be resent by the system at a later time (when it comes back up for example) and so no information will be lost.  There are times when messages can be orphaned in the MQ tables and cause a system slowdown because of a SQL statement or perhaps the system came down unexpectedly.

The easiest and most common way to clear out these tables is to perform a COLD restart.  A COLD restart is a specific way to bring up a Automic system that is described in KBE 255.  It is not a simple restart of the system, nor the server on which the system resides.