SQL Server Performance

report/output about SQL 2000's Lock Owner Blocks

Discussion in 'Performance Tuning for DBAs' started by ufobox, Feb 27, 2003.

  1. ufobox New Member

    Does anybody has a script/stored-procedure to general a report/output about SQL 2000's Lock Owner Blocks in order to collect the real-time statics?
    It can be run by manually or certain interval (like every 5 mins).

    I know we can use sql-profiler or performance monitor to do this.
    But I need a script like this also.

    Thanks.
  2. satya Moderator

Share This Page