SQL error: TIMEOUT on INSERT INTO dbo.AuditEvent_AlertQueue_AlertQueue (4306593)

In the Coordinator logs, the following error message is displayed:

Long running query detected.

SQL error: TIMEOUT on INSERT INTO dbo.AuditEvent_AlertQueue_AlertQueue

This usually comes with performance issues and error like below:

Resolution

• Run the following SQL Script on SQL Server Management Studio to identify the problematic Alert(s):

exec [dbo].[usp_AlertHistoryCountsByQuery]

• Once done, check the QueryName where the Alert Count are the highest
• Go to CA Client and search for the Alert(s)

• Disable the Alert(s) then right-click, Alert | Delete History

• Run the SQL Script again every few hours to make sure the Alert Count has gown down to 0 then enable the Alert again

Note: This will take time to proceed and the environment will take time to process all the action ongoing at the same time so please plan this for a low activity period.

• Check the Coordinator logs to confirm the issue is not present anymore