MS SQL Server - Find a name of an index in deadlock situation.

Author

Find a name of an index in deadlock situation.

Yitzak

2006-11-29, 7:12 pm

Hi

I have a deadlock occurring.

Using MSSQL 2005 current activity lock screens I can see one process is
waiting for a lock to be released on a Database object. with objectId =
1441294802092032 and type = KEY - so I know I have a lock on an Index
and what table the index belongs to,

But how can I find the name of the index that is blocked??

This was part of the default view in SQL2000 activity manager. I cannot
use object_name (1441294802092032 ).

Pain is cannot even export the details of the locks per process to a
file.

Uri Dimant

2006-11-30, 5:17 am

Yitzak
http://blogs.msdn.com/bartd/archive.../09/747119.aspx

"Yitzak" <terryshamir@yahoo.co.uk> wrote in message
news:1164814916.178901.38620@16g2000cwy.googlegroups.com...
> Hi
>
> I have a deadlock occurring.
>
> Using MSSQL 2005 current activity lock screens I can see one process is
> waiting for a lock to be released on a Database object. with objectId =
> 1441294802092032 and type = KEY - so I know I have a lock on an Index
> and what table the index belongs to,
>
> But how can I find the name of the index that is blocked??
>
> This was part of the default view in SQL2000 activity manager. I cannot
> use object_name (1441294802092032 ).
>
> Pain is cannot even export the details of the locks per process to a
> file.
>

Sponsored Links