EventClass translation follow-up

  • Remember a while back I posted asking if anyone knew about a SQL Server queryable object for translating EventClass integers into the text? Well, earlier today I had one of my mini-inspirations. Since Performance Dashboard displays both the integer and text for trace events (in the traces report), I surmised that it it has to be getting the data from somewhere and I just might be able to figure it out. So I did one of my standard tricks and ran a Profiler trace on the DB while I opened up that particular report.

    Lo and behold, there is indeed a queryable object for EventClass translation. It's sys.trace_events. There's a few other DMV's for traces too (just search BOL for sys.trace_). You can also find a few functions for trace data as well.

    It's not perfect. The table stops at 202. I know for a fact that there are others (such as 65534 and 65533 are stop / start trace events).

  • plus, we're missing analysis services EventClass Ids...

Viewing 2 posts - 1 through 1 (of 1 total)

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