Event ID 318 | Unable to read local eventlog (reason: The data area passed to a system call is too small)

On one of the production servers we would receive this error message in the SQL Server Agent log file at least once in a day.

********

Event ID 318 | Unable to read local eventlog (reason: The data area passed to a system call is too small)

*******

From the description this message it is clear that this is an informational note. This article has more information on this Even ID 318. Some other application running on the same server where SQL Server is running and it fails. This information is logged in the Application Event Log. SQL Server Agent also reads the Application Event Log to look for the alerts defined under Alerts in SQL Server. When SQL Server Agent reads this application error it raises Event ID 318.

In our server, this was confirmed. A few seconds before this error was logged in SQL Server Agent log file, the TSM Backup service terminated abruptly and DrWatson had the error.

****************************

Event Type:     Information
Event Source:     DrWatson
Event Category:     None
Event ID:     4097
Date:          8/23/2010
Time:          1:31:52 AM
User:          N/A
Description:
The application, C:Program FilestivoliTSMbaclientdsmcsvc.exe, generated an application error The error occurred on 08/23/2010 @ 01:31:52.481 The exception generated was c0000005 at address 72E5DE02 (<nosymbols>)

****************************

So when we see this error in the Agent Log file, no need to panic. Something else failed on the server and SQL Server Agent chose this way to inform that to the DBA.

One thought on “Event ID 318 | Unable to read local eventlog (reason: The data area passed to a system call is too small)

  1. Pingback: Export the Event Logs without opening MMC - SQL Server - SQL Server - Toad World

Comments are closed.