Post reply

PROFILER: What events should i check..

  • February 26, 2010 at 4:10 am

    #143138

    Hello,

    I need to put profiler runnning to get all queries that are running more than 5 seconds.

    But i must get only the code that is usefull to future analysis with user and location from the source (location).

    Last time they used profiler the server stays frease for one hour so i'm worried on how can i do it with less impact as possible.

    What events should i check?

    How can i put profiler running with less impact ás possible?

    Should i put all data returned in a table or in a file?

    The only thing i know is that the server stays a lot of times frease and as usual the client tell us that is the SQL Server that is performing this situation.

    Hope you can help me.

    Thanks and regards,

    JMSM 😉

  • February 26, 2010 at 4:18 am

    #1125479

    These may be worth reading

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 26, 2010 at 4:28 am

    #1125481

    Thanks Gilla.

    Regards,

    JMSM 😉

  • February 26, 2010 at 4:43 am

    #1125487

    Gail,

    I appreciate a lot all your posts and all information where you act as principal focus.

    As i told you a lot of times ....... hope one day be so useful as you are!! :Wow: ...... :blush:

    Once more, thanks a lot Gilamonster.

    Regards,

    JMSM 😉

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

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