SQL 2005 Standard Trace Template

  • In SQL 2005 Standard Trace Template, are there any documentation explanining each fields ( for ex: clientprocessid )

  • Books Online?

    http://msdn.microsoft.com/en-us/library/ms175481%28SQL.90%29.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • In Profiler, this is given for clientProcessID: The process id of the application calling sql server. Does this mean, that a particular application, say excel would have the same clientprocessid at that time or is it different?

    I could not locate the correct page which explains all the fields.

  • balasach82 (7/6/2010)


    In Profiler, this is given for clientProcessID: The process id of the application calling sql server. Does this mean, that a particular application, say excel would have the same clientprocessid at that time or is it different?

    It's the processID that you see if you open task manager on a client machine. Different every time the application runs.

    I could not locate the correct page which explains all the fields.

    The link I gave you lists each event that profiler can trace. Each event then lists the columns that event populates and what the values they'll have. I don't think there's a master-list of columns because for some of them their values have different meanings for different events.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Gail's already pointed you to the best resource, Books Online, but the second best resource on the general topic of Trace, Trace Events and the Profiler is Brad Magehee's book.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply