table/index and page mapping

Re: table/index and page mapping

have you tried using sp_lock ?

Re: table/index and page mapping

These information are gathered from scheduled jobs so when I discover
that, it's already gone.

But one thing I would like to know, is there a clear way on how to map
a page_id to a particular object, i.e. how can I know which object is
involved when given a particular page id?

Re: table/index and page mapping

New MSSQL DBA (boscong88@gmai l.com) writes:[color=blue]
> I've just found a blocking lock occuring in a SQL Server.
>[color=green]
>>From the waitresource, I found that the blocker has the following[/color]
> 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:fil e_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.[/color]

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...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@sommarsk og.se

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

Re: table/index and page mapping

Hi

You may want to look at getting "Inside SQL Server 2000" by Kalen Delany
ISBN
0-7356-0998-5.

John

"New MSSQL DBA" <boscong88@gmai l.com> wrote in message
news:1117705487 .890027.197150@ g47g2000cwa.goo glegroups.com.. .[color=blue]
> These information are gathered from scheduled jobs so when I discover
> that, it's already gone.
>
> But one thing I would like to know, is there a clear way on how to map
> a page_id to a particular object, i.e. how can I know which object is
> involved when given a particular page id?
>[/color]