System Internal Views
System internal views are system views that make available low-level storage metadata for the SQL Server Database Engine.
The following table lists and describes the system internal views.
 Important |
|---|
These views are reserved for Microsoft SQL Server internal use only. Future compatibility is not guaranteed. |
View name | Description |
|---|---|
sys.system_internals_partitions | Contains a combination of rowset and hobt information. There is a one-to-one correspondence between rowset and hobt. |
sys.system_internals_partition_columns | Contains both rowset and hobt column information. It also contains type and other information redundantly copied from the catalog of the relational engine. |
sys.system_internals_allocation_units | Contains a row for each allocation unit in the current database. |
