需要sys.partitions與sys.allocation_units做連線，如查詢allocation_unit_id=281474980249600所屬物件名稱：

1> SELECT object_name(object_id) AS object_name
2> FROM sys.partitions p JOIN sys.allocation_units a
3> ON p.partition_id = a.container_id
4> WHERE a.allocation_unit_id=281474980249600;
5> go
object_name
------------------------------------------------------
sysidxstats

[@more@]

由allocation_unit_id查詢其所屬物件名稱

相關文章