October 11, 2007 at 2:27 pm
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).
October 29, 2007 at 8:59 am
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