Results 1 to 2 of 2

Thread: locks

  1. #1
    Join Date
    Jul 2008
    Posts
    10

    Unanswered: locks

    hey,

    does anyone know a way that i can monitor the number of locks being used.

    there is sp_locks this shows what is locked

    sp_monitorconfig "number of locks" does tell me the number of locks. but does not give me a moment in time reading. it only shows the maxium ever reading.

  2. #2
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    You may query master.dbo.syslocks table:

    SyBooks Online

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •