Return
-
Title
SQL error: TIMEOUT on INSERT INTO dbo.AuditEvent_AlertQueue_AlertQueue -
Description
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:
-
Cause
This is mostly due to a Report or Alert History log become big -
Resolution
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