Posted by Erland Sommarskog on 06/05/05 00:51

New MSSQL DBA (boscong88@gmail.com) writes:
> I've just found a blocking lock occuring in a SQL Server.
>
>>From the waitresource, I found that the blocker has the following
> information:
> wait_info: PAGEIOLATCH_EX
> wait_resource: 14:1:564312
>
> And the blockee has the following information:
> wait_info: LCK_M_S
> wait_resource: KEY: 14:405576483:2 (7501a5aa8355)
>
> The problem is that I do not know which object is the blocker holding,
> for I understand that for a PAGE lock, it is in the format of
> database_id:file_id:page_id
>
> I know the db_id, the file_id but don't know how to map the page_id
> (564312) to a table/index in the database.
>
> Can somebody shed some lights on this? thks a lot.

DBCC PAGE is good for this. This command is however not documented.
I did find a KB article about, but it's very ancient:
http://support.microsoft.com/default.aspx?scid=kb;en-us;83065.
You may still be able to find the information, though. Somewhere in
the output, there is an object id.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]