October 28, 2002 at 6:55 am
Hello,
I have a script which create a trace with the option to write to disk in a file. This trace creates the file, but the size of this file is 0 Kb all the time the trace is running. I can't open this file with Profiler or fn_trace_gettable because has this size. If I stop the trace, the size became != 0 and I can open it. I want to know if it is a possibility to open the file an see all the events without stopping the trace.
Thank you for any ideea!
October 28, 2002 at 10:03 am
I do not believe you can because this file is being written to. You can set a smaller rollever, however and then grab the files once the trace has rolled to a new file.
Steve Jones
October 29, 2002 at 1:59 pm
There are ways to read files that locked by a writing process.
"type filename | more" on the command line always works as far as I know.
Several editors can do the same. I have good experiences with emacs and credit.
I never tried it on SQLServer trace files, but it works fine on logfiles that I cannot open with notepad.
Credit is probably the easiest to use. You can download it from http://www.praven3.com/credit/ for free.
Joachim.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply