Post reply

view table's lock and historical lock

  • March 2, 2023 at 1:37 am

    #4155759

    I have the following questions, thank your kind help!

    1. how to find the active lock on a table?

    2. is there any way to view the historical lock information of one table?

  • March 2, 2023 at 9:42 am

    #4155888

    A simple search will yield many results for these questions.

    1 - Use the DMV sys.dm_tran_locks

    2 - Not unless you have historical monitoring in place, to monitor sys.dm_tran_locks

  • March 27, 2023 at 7:48 am

    #4165330

    thanks for giving helpful answer

    regards: vidmate

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply