| Event Id | 1009 |
| Source | NotificationServices |
| Description | The timeout period elapsed prior to the completion of a Transact-SQL statement. |
| Event Information | According to Microsoft: Cause: This error occurs when an executing query or stored procedure does not complete within the specified timeout. It typically indicates that SQL Server is too busy. (A different error message is returned if the execution of an event rule or a subscription rule exceeds the timeout specified in the ActionTimeout parameter.) The event log entry for this error includes the description of the actual error that caused it. User Action : Examine the event log entry for additional information on the action that timed out. If vacuuming was the cause of the failure then it may be necessary to manually vacuum expired events and notifications by running the NSVacuum stored procedure. Notification Services uses a timeout value of 30 seconds for many operations. If possible, reduce the processing of the affected action such that it can complete within 30 seconds. |
| Reference Links | The timeout period elapsed prior to the completion of a Transact-SQL statement. |
Catch threats immediately
We work side-by-side with you to rapidly detect cyberthreats
and thwart attacks before they cause damage.