SQL Server 2000, Event Log Error, Error Id - 318

Posted on 2010-01-06
Last Modified: 2012-05-08
Unable to read local eventlog (reason: The data area passed to a system call is too small).

This error is recorded in the event log every minute in the production server, and because of this the SQL Server 2000 performance is very slow and the box is also working slow.

This indirectly affects my application and productivity.
Experts Please help me.
Question by:dinudany
    LVL 4

    Assisted Solution

    The SQLSERVERAGENT error Event id: 318 is a result of an unhandled exception raised by another
    application that runs on the same computer as SQL Server. SQL Server Agent reads the
    application event log to respond to SQL Server events defined in the SQL Server Agent alert.
    Dr. Watson handles the "unhandled exception" and records the error information raised by
    the application in the Windows Application log. SQL Server Agent reads the error entry
    from the Windows application log and generates error Event id: 318.
    LVL 2

    Author Comment

    What is Dr. Watson?, and i have checked with application, their are only viewstate errors occurring in the application, not unhandled exceptions
    LVL 4

    Assisted Solution

    It is just a sample for an application that raises errors to the windows event log.
    At any rate 318 is an error generated by SQL server agent which is caused by another application (which is not SQL server) writing error to the event log.
    Are the viewstate errors the only errors in the event log?
    If so, than they are the only ones responsible for the SQL agent 318 errors.
    BTW - documentation states you can disregard the 318 errors and that they have no effect on SQL server.
    LVL 2

    Accepted Solution

    thanks bro;

    I finally found that the viewstate error occurring in the web page was the cause for the SQL Agent 318 errors. and then now when i have solved those, the server is not getting this type of error,

    finally, i commit the viewstate error in web pages cause this issue, by solving it, one could easily get rid of this error.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Loading csv or delimited data files to MySQL database is a very common task frequently questioned about and almost every time LOAD DATA INFILE comes to the rescue. Here we will try to understand some of the very common scenarios for loading data …
    A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi ( had suggested a “sed” way, I actually shell …
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now