Reading a trace.

[williamkremer]

Happy Friday! I'm running a trace to monitor users activities on a server and I want to save it as a readable document. Notepad saved as MyTrace.trc is unreadable. Any suggestions please?


"You cannot hold a torch to another man's path without brightening your own"
Best regards,
Bill

 

[SQLDenis]

I usually save the trace to a table, remove all the stuff I don't need
And if I need to I can export that to any format I want

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[Jamfool]

select * from ::fn_trace_gettable('c:\DurationTrace.trc', default)

 

[Jamfool]

oops missed the end of my comment off. Once you have it you can then save it in any format you wish.

 

[druer]

I do the same as Dennis. The flexibility of being able to query for exactly what you want, or get counts of specific activity types is very, very nice.

 

[williamkremer]

Yes. That all sounds good to me. Thanks again.

"You cannot hold a torch to another man's path without brightening your own"
Best regards,
Bill

 

[williamkremer]

To druer: you are so right! It's actually fun! Very powerful and flexible (It will be a ponderously hugh table, but oh well. I'll just drop it later when I find out what info I need)

"You cannot hold a torch to another man's path without brightening your own"
Best regards,
Bill

 

[vongrunt]

My vote for trace results in table too - once you convert TextData column to varchar(somelength).

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[williamkremer]

Did that! in my database that textdata field reveals LOTS of interesting stuff. Background code, etc. Cool. In Santa Cruz, CA (my home) Jack O'Neill is the guy who invented the wetsuit for surfers, not Stargate! His name is everywhere.

"You cannot hold a torch to another man's path without brightening your own"
Best regards,
Bill