July 16, 2009 at 5:09 pm
Hi,
I'm using SQL Profiler to profile analysis services, but when I output to a table both the "EventClass" & "EventSubclass" columns have integer values instead of the full description as seen in the trace. Is there a system table that has the descriptions of the SSAS event classes & subclasses so that I can join to it?
Thank you inadvance for your help.
aldynguyen
July 17, 2009 at 9:05 am
I know you can get this for the Database Engine from system tables, but for SSAS I don't think you can. It can be found in the tracedefinition90.xml. This file is typically located in your installations MSQL.x\OLAP\bin\Resources\1033. I found this here
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply