Profiler's EventClass value in a table

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Profiler's EventClass value in a table

Author

Topic

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-11-06 : 05:51:39

in profiler there's a column called EventClass
and that column shows stuff like RPC:Completed, SQL:BatchStarting, etc...
now in the profiler i go to File-Save as->Table
and pick a server table etc and save it.
in that table there is also of course the EventClass column
but the eventclass column in the table holds the id of the event class so instead of saying RPC:Completed it has a number 13.

same thing if i save to a file and use fn_trace_gettable

any idea how to map that id from the table to a value from the profiler? so that i don't have to do manual mapping for each class which is mildly put annoying.

Thanx

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-11-06 : 09:43:14

Hey Spirit, Tara asked this question recently, here is the thread:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=91655

Here is the answer:

use master;
GO
select * from sys.trace_events;

Future guru in the making.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-11-06 : 09:57:46

thanx! awsome!

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources