Post reply

Alternate options of SQL Profiler

  • June 26, 2011 at 2:18 am

    #98211

    Is there any alternative of sql server profiler. infact an option of any tool. I want to have an option to get data like that of profiler but it should be some good option since i profiler is creating extra load on server. I tried the option SET Profiler. This option is very tricky since when i m using loop upto 1000 then this option displays data 1000 times.

    I want some good inbuild feature of sql server that can be an alternative to sql profiler tool.

  • June 26, 2011 at 3:00 am

    #1344192

    Use a server-side trace (profiler without the GUI)

    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

  • June 27, 2011 at 12:06 am

    #1344311

    How to do that?.

  • June 27, 2011 at 2:54 pm

    #1344842

    http://www.google.com/search?q="SQL+Server"+Server-side+trace

    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

  • June 27, 2011 at 9:43 pm

    #1344938

    Depending on what you're looking for, you can right-click a server is SSMS and then select "Reports". There you will find a large number of reports and some of the are "profiler-like" in that you can find things like longest running queries, most cpu intensive, most IO intensive, etc, etc.

    If you're long in tooth, you can also use some of the DMV's to find that same information on a scheduled basis.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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