none
ETW Correlation in IIS and SQL Server events

    Question

  • For correlating events in tracelogs in our application, I am capturing ETW traces from below listed providers
    MSSQLSERVER Trace                        {FBD367D1-642F-47CF-B79B-9BE48FB34007}
    IIS: WWW Server                          {3A2A4E84-4C21-4981-AE10-3FDA0D9B0F83}

    IIS populates valid 'Correlation ActivityID' in its etl logs.
    e.g. <Correlation ActivityID="{00000000-0000-0000-8603-0080000000f0}" />

    However, SQL Server etl log always have it as
    e.g. <Correlation ActivityID="{00000000-0000-0000-0000-000000000000}" />

    My question is -
    How do I achieve correlation of events between IIS and SQL Server, if the 'Correlation ActivityID' is always 0 in SQL Server traces?

    Or

    How do I start getting valid 'Correlation ActivityID' in SQL Server etl traces?


    Wednesday, February 22, 2012 6:26 AM

Answers

All replies

  • Hello Rushikesh,

    Thank you for your question.

    I am trying to involve someone familiar with this topic to further look at this issue.


    Best Regards,
    Iric
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Thursday, February 23, 2012 8:11 AM
    Moderator
  • Hello,

    Can you apply the patch as in Kb article http://support.microsoft.com/default.aspx?scid=kb;EN-US;976124 or move to the latest service pack and test it. What version of SQL you are using.

    Thank You

    Jayaprakash Jo - MSFT

    Wednesday, February 29, 2012 12:43 AM
    Answerer