Use sp_familylock to display the partition locks held by a family.
View locked partitions in the partitionid column of the sp_familylock report.
sp_familylock go Fid spid loid locktype table_id partitionid page dbname class context ------ ------ ------ ------------------- --------------- ---------------- -------- ----------- ---------- ------------------------------ 25 19 50 Sh_cpartition 672002394 -1 0 userdb Non Cursor Lock LOCK CONTEXT VALUES 25 19 50 Sh_partition 672002394 688002451 0 userdb Non Cursor Lock LOCK CONTEXT VALUES 25 20 50 Sh_cpartition 672002394 -1 0 userdb Non Cursor Lock LOCK CONTEXT VALUES 25 20 50 Sh_intent_partition 672002394 688002451 0 userdb Non Cursor Lock LOCK CONTEXT VALUES 25 20 50 Sh_partition 672002394 704002508 0 userdb Non Cursor Lock LOCK CONTEXT VALUES 25 25 50 Sh_intent 672002394 0 0 userdb Non Cursor Lock LOCK CONTEXT VALUES (6 rows affected) (return status = 0)