SQL Server Performance Forum – Threads Archive
sp_lock2
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 lockmay be this can help
http://support.microsoft.com/kb/83065 Girish Patil
MS-SQL DBA
http://www.facebook.com/p/Girish_Patil/517990969
*** This posting is provided AS IS with no rights for the sake of knowledge sharing. ***
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.
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.
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.
to run DBCC Page you need to turn on the TRACE Flag 3204. ***********************
Dinakar Nethi
SQL Server MVP
***********************
http://weblogs.sqlteam.com/dinakar/
]]>