Question: Profiler trace!!!

• JMSM

  SSCertifiable

  Points: 5440

  More actions

  March 3, 2010 at 4:40 am

  #211796

  Hello again,

  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.:crying:

  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,

  JMSM

• Leo Leong

  SSCommitted

  Points: 1615

  More actions

  March 5, 2010 at 12:00 am

  #1128994

  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]

• JMSM

  SSCertifiable

  Points: 5440

  More actions

  March 5, 2010 at 2:40 am

  #1129047

  Thanks a lot.

  Regards,

  JMSM