Home Forums SQL Server 2005 Administering Locks - Blocked Processes RE: Locks - Blocked Processes

  • August 12, 2009 at 1:52 am

    #1037874

    sp_who2 is ur friend. You can use following from performance monitor:

    SQLServer:Locks Lock Timeouts/sec _Total

    SQLServer:Locks Number of Deadlocks/sec _Total

    -LK