Questions:
1st How can i see what event is the one in the first raw as the procedure name appears NULL
-- You can capture EventClass column (27) in your profiler
2nd Am i doing the conversion to minutes well?
I need to get all the info that was running more than a minute but i'm completely lost on how should i change the data used to minutes/seconds.:crying:
-- in SQL Server 2008, duration field stores microsecond. So, 1,000,000 = 1 second
3rd I put @maxfilesize = 3000 in the profiler template (Aux-Profiler-Template.txt)
I need to know if the file will be rewrited if the file growth to 3GB (@maxfilesize) before end time?
-- @maxfilesize = 3000 means a new trace file will be generated (automatically) when current trace file reached 3GB of size.
4th Can i use any parameter that create a new file(s) when the maxfilesize will be at limit?
-- refer 3rd. you don't need to. file name will be appended will a running number.
[/quote]