MS SQL Server - find out lock start time

Author

find out lock start time

Zeng

2006-10-24, 6:29 pm

I think it would be great to investigate into system performance and dead
lock if we can find out the start time for the current locks. Is there a way
to do that? thanks!

I tried the following 2 methods:
1) EXEC sp_lock
2) In the enterprice manager | management | current activities |
locks/object

Neither view gives me what I'm looking for.

thanks again!

Andrew J. Kelly

2006-10-24, 6:29 pm

Maybe these will help:

http://msdn.microsoft.com/library/d...atabse_5xrn.asp
Troubleshooting Deadlocks
http://www.support.microsoft.com/?id=224453 Blocking Problems
http://www.support.microsoft.com/?id=271509 How to monitor SQL 2000
Blocking

--
Andrew J. Kelly SQL MVP

"Zeng" <zeng@nononospam.com> wrote in message
news:%23ATn9732GHA.2096@TK2MSFTNGP05.phx.gbl...
>
> I think it would be great to investigate into system performance and dead
> lock if we can find out the start time for the current locks. Is there a
> way to do that? thanks!
>
> I tried the following 2 methods:
> 1) EXEC sp_lock
> 2) In the enterprice manager | management | current activities |
> locks/object
>
> Neither view gives me what I'm looking for.
>
> thanks again!
>

Sponsored Links