Table of Contents

Class ObjectSchema.AllocationUnit

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.allocation_units (Transact-SQL)

Applies to: √ SQL Server (all supported versions) √ Azure SQL Database

Contains a row for each allocation unit in the database.


See sys.allocation_units.

[Table(Schema = "sys", Name = "allocation_units", IsView = true)]
public class ObjectSchema.AllocationUnit
Inheritance
ObjectSchema.AllocationUnit
Extension Methods

Properties

AllocationUnitID

ID of the allocation unit. Is unique within a database.

[Column("allocation_unit_id")]
[NotNull]
public long AllocationUnitID { get; set; }

Property Value

long

ContainerID

ID of the storage container associated with the allocation unit.

If type = 1 or 3 in a rowstore index container_id = sys.partitions.hobt_id.

If type = 1 or 3 in a columnstore index, container_id = sys.column_store_row_groups.delta_store_hobt_id.

If type is 2, then container_id = sys.partitions.partition_id.

0 = Allocation unit marked for deferred drop

[Column("container_id")]
[NotNull]
public long ContainerID { get; set; }

Property Value

long

DataPages

Number of used pages that have:

In-row data

LOB data

Row-overflow data



Note that the value returned excludes internal index pages and allocation-management pages.

[Column("data_pages")]
[NotNull]
public long DataPages { get; set; }

Property Value

long

DataSpaceID

ID of the filegroup in which this allocation unit resides.

[Column("data_space_id")]
[Nullable]
public int? DataSpaceID { get; set; }

Property Value

int?

TotalPages

Total number of pages allocated or reserved by this allocation unit.

[Column("total_pages")]
[NotNull]
public long TotalPages { get; set; }

Property Value

long

TypeColumn

Type of allocation unit:

0 = Dropped

1 = In-row data (all data types, except LOB data types)

2 = Large object (LOB) data (text, ntext, image, xml, large value types, and CLR user-defined types)

3 = Row-overflow data

[Column("type")]
[NotNull]
public byte TypeColumn { get; set; }

Property Value

byte

TypeDesc

Description of the allocation unit type:

DROPPED

IN_ROW_DATA

LOB_DATA

ROW_OVERFLOW_DATA

[Column("type_desc")]
[Nullable]
public string? TypeDesc { get; set; }

Property Value

string

UseDPages

Number of total pages actually in use.

[Column("used_pages")]
[NotNull]
public long UseDPages { get; set; }

Property Value

long