View Partition Locks with sp_lock

Use sp_lock to view partition locks currently held by SAP ASE.

View locked partitions in the partitionid column of the sp_lock report.

This example displays locks, including partition locks, currently held by SAP ASE.
sp_lock
go

fid spid loid locktype table_id partitionid page row dbname class context
--- ---- ---- -------- -------- ----------- ---- --- ------ ------ ------- 
0 13 26 Ex_intent 420193516 0 0 0 master Non Cursor Lock
0 13 26 Ex_intent_partition  420193516 452193630 0 0 master Non Cursor Lock
0 13 26 Ex_page 420193516  452193630 4993 0 master Non Cursor Lock
0 14 28 Ex_intent 420193516 0 0 0  master Non Cursor Lock
0 14 28 Ex_intent_partition 420193516 468193687 0 0  master Non Cursor Lock
0 14 28 Ex_page 420193516 468193687 5001 0 master Non Cursor Lock
0 16 32 Sh_intent 1006623598 0 0 0 master Non Cursor Lock
Related concepts
sp_lock