When index lock contention occurs how would I know which index is causing
Hi,
We have occurrences of enq : TX - index contentions in the database. Using the SQL ID, we have identified the INSERT statement and the table which they are trying to insert.
This table has almost 25 different indexes, some of which are unique as well.
I am wondering how to identify the actual index causing issue, out of these 25 indexes.
Is there any way to pin point to the name of index which is causing the lock?
My plan is, once the index is identified, I would like to check the extents and inittrans and other attributes of this index to fix.
Thanks
Krishna