SQL Server Performance

sp_lock2

Discussion in 'SQL Server 2005 General DBA Questions' started by priyaram, Apr 19, 2007.

  1. priyaram New Member

    hi

    i executed the sp_lock2 stored proc, and i got one page lock info for one table.

    is there a way i can use to find which page/what data in that table got loacked

    (i.e) what to know the underlying data that is loacked by the page lock
  2. gvphubli New Member

  3. MohammedU New Member

    Check SQL Server 2005 Books Online topic "Lock Modes" for more info about sp_lock2 output...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  4. satya Moderator

    Girish's link should get you more information on using DBCC PAGE statement to see where exactly the problem is, also you might turn the trace flag to find any deadlock information.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  5. MohammedU New Member

    I don't think sp_lock2 gives you page information to run dbcc page....
    And I think poster got one page of lock information of a table.


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  6. ndinakar Member

    to run DBCC Page you need to turn on the TRACE Flag 3204.

    ***********************
    Dinakar Nethi
    SQL Server MVP
    ***********************
    http://weblogs.sqlteam.com/dinakar/

Share This Page