locked
Event Tracing for Windows failed to send an event. RRS feed

  • Question

  • My SQL Server 2005 SP4 on Windows 2008 R2 is flooded with the below errors:-

    Date  10/25/2011 10:55:46 AM
    Log  SQL Server (Current - 10/25/2011 10:55:00 AM)

    Source  spid

    Message
    Event Tracing for Windows failed to send an event. Send failures with the same error code may not be reported in the future. Error ID: 0, Event class ID: 54, Cause: (null).

     

     

    Is there a way I can trace it how it is coming?

    When I check inputbuffer for these ids, it looks like it is tracing everything.

    All the general application DMLs are coming in these spids.

     

     

    Tuesday, October 25, 2011 7:07 AM

Answers

  • Hi Namit Sehgal,

    It seems that the SQL Server instance has enabled the Windows extended event (ETW). The provider name of ETW is composed by “Instance name” and "Trace”. You can check whether check if it is active on the server and stop it is necessary. The blog below elaborated on using ETW for SQL Server 2005: http://blogs.msdn.com/b/sqlqueryprocessing/archive/2006/11/12/using-etw-for-sql-server-2005.aspx.

    Best Regards,
    Stephanie Lv


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    • Marked as answer by Namit Sehgal Thursday, October 27, 2011 6:48 AM
    Thursday, October 27, 2011 6:28 AM

All replies

  • Hi Namit Sehgal,

    It seems that the SQL Server instance has enabled the Windows extended event (ETW). The provider name of ETW is composed by “Instance name” and "Trace”. You can check whether check if it is active on the server and stop it is necessary. The blog below elaborated on using ETW for SQL Server 2005: http://blogs.msdn.com/b/sqlqueryprocessing/archive/2006/11/12/using-etw-for-sql-server-2005.aspx.

    Best Regards,
    Stephanie Lv


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    • Marked as answer by Namit Sehgal Thursday, October 27, 2011 6:48 AM
    Thursday, October 27, 2011 6:28 AM
  • Hi,

    This post helped me a lot.

    I deleted the trace.But still we are observing the error.

    Apologies to comment on the old post.

    Thursday, October 15, 2015 10:49 AM