Hi Jacob,

Thanks for the help so far !!!

I have figured out the cause of such enormous locks. 🙂 🙂 There was a cleanup job scheduled on documentum server and was...

Small correction to my earlier response :

It is Ghost cleanup process acquiring locks not the lazy writer.

Sorry for confusion.

Thanks.

Hi ,

Please find the below response :

I have addded DB name in to the output list :

Now the time for same SPID has been changed :

Start time ...

Hi ,

Modified the script a bit as :

SELECT

last_request_end_time,

host_name,

login_name,

program_name,

sysr.open_transaction_count,

is_active=ISNULL((SELECT 1 FROM sys.dm_exec_requests req WHERE req.session_id=ses.session_id),0),

ses.transaction_isolation_level,

text.text

FROM sys.dm_exec_sessions ses

INNER JOIN sys.dm_exec_connections con

ON ses.session_id=con.session_id

inner join sys.dm_exec_requests sysr

on ses.session_id=sysr.session_id

CROSS APPLY sys.dm_exec_sql_text(con.most_recent_sql_handle)...

Hi Jacob,

Thanks for the response!

I would like to highlight the bifurcation of count of locks in the SPID (or one transaction) :

resource_typerequest_modecount of locks

OBJECT ...