Post reply

Question: Profiler trace!!!

  • 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 😉

  • 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]

  • March 5, 2010 at 2:40 am

    #1129047

    Thanks a lot.

    Regards,

    JMSM 😉

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply