Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    12

    Unanswered: blocks & deadlocks

    In the production server we are noticing blocks & dead-locks. I have used trace flag 1204 to capture info for deadlock which hapens very rarely.
    I am seeing blocks every now & then. Is there any tools/system tables to query to get more info abt blocking & blocked spids. I used info from syslockinfo & sysprocess. dbcc inputbuffer gives info like 'sp_cursorunprepare;1' or 'sp_cursorfetch;1' and puts exclusive locks on bunch of tables. However no activity is seen for that spid.

    Any help will be appreciated. I am using SQL Server 2000 with SP2

    Rachael

  2. #2
    Join Date
    Jan 2003
    Location
    México City
    Posts
    31

    Re: blocks & deadlocks

    Try with sp_who2 and adding (NOLOCK) in your selects.
    César.

Posting Permissions

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