sp_lock

The partitionid column has been added to the output of the sp_lock stored procedure.

Table lock and fine-grained lock values for partitionid are 0. partitionid is populated only for partition-level locks.

This example shows all 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
View Partition Locks with sp_lock