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.

   ufobox, Feb 27, 2003

   #2
2. satya Moderator

   Try searching inhttp://www.swynk.com, I'm sure have seen the similar code example.
   
   HTH
   
   Satya SKJ
   

   satya, Feb 28, 2003

   #2

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in