Post reply

Find Locks and Blocking sessions for a time period

  • August 13, 2013 at 5:53 am

    #278592

    Hi All,

    I would like to find a way to find all types of locks which are more than 5secs and blocking processes which are for more than 10secs. I know we can use Profiler but this adds to the CPU burden on production. Is there an alternative to using profiler?

  • August 13, 2013 at 8:05 am

    #1640949

    Profiler is a GUI interface to trace, which does put an extra load on the server. Run the trace server side instead.

    There is a stairway series on server side traces at http://www.sqlservercentral.com/stairway/72363/

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

  • August 14, 2013 at 7:45 am

    #1641396

    harikumar.mindi (8/13/2013)

    Hi All,

    I would like to find a way to find all types of locks which are more than 5secs and blocking processes which are for more than 10secs. I know we can use Profiler but this adds to the CPU burden on production. Is there an alternative to using profiler?

    You can run a server-side trace, much better option

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

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