As i was reading in a fantástic link send by Gail Shaw, i put a profiler running to catch all the queries in a period o time but, now i've got more questions about it.
I attach a file Aux-Profiler.xlsx
where i've inserted all the data that becomes from one *.trc file:Questions: 1st
How can i see what event is the one in the first raw as the procedure name appears NULL 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.
The only diference between what i've been doing and the fabulous link (http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/)
is that when creating my table i change the field TextData from varchar(4000) to varchar(max)
I send you to the file with all the steps (Aux-Profiler-Steps.txt)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?4th
Can i use any parameter that create a new file(s) when the maxfilesize will be at limit?
Thanks and regards,