Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Find Locks and Blocking sessions for a time period RE: Find Locks and Blocking sessions for a time period

  • 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