- 论坛徽章:
- 0
|
I have a long-running transaction in my application which include "Cursor", the question is, I can not find out the exactly "Cursor" in the transation because it's provided by a third-party vendor.
So I ran sp_lock and sp_who, outout as below:
-- sp_lock
fid spid loid locktype table_id page row dbname class context
----------- ----------- ----------- -------- ----------- ----------- ----------- ------ ----- -------
0 435 870 Sh_intent 23 0 0 yest Non Cursor Lock
0 435 870 Sh_intent 24 0 0 yest Non Cursor Lock
0 435 870 Sh_intent 1533504690 0 0 yest Cursor Id 28508161
0 435 870 Sh_intent 1565504804 0 0 yest Cursor Id 28508161
-- sp_who
fid spid status loginame origname hostname blk_spid dbname cmd block_xloid
----------- ----------- ------ -------- -------- -------- -------- ------ --- -----------
0 435 running actuate actuate cs2 0 yest OPEN CURSOR 0
Is it possible to find out what's "Cursor Id 28508161"?
I've tried dbcc sqltext(435) but the result is not what I want, anybody help? Many thank! |
|