Class ObjectSchema.IndexResumableOperation

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.index_resumable_operations (Transact-SQL)

Applies to: √ SQL Server 2017 (14.x) and later √ Azure SQL Database

sys.index_resumable_operations is a system view that monitors and checks the current execution status for resumable Index rebuild or creation.
Applies to: SQL Server (2017 and newer), and Azure SQL Database

See sys.index_resumable_operations.

[Table(Schema = "sys", Name = "index_resumable_operations", IsView = true)]
public class ObjectSchema.IndexResumableOperation

Inheritance

object

ObjectSchema.IndexResumableOperation

Extension Methods

Map.DeepCopy<T>(T)

Properties

IndexID

ID of the index (not nullable). index_id is unique only within the object.

[Column("index_id")]
[NotNull]
public int IndexID { get; set; }

Property Value

int

LastMaxDop

Last MAX_DOP used (default = 0)

[Column("last_max_dop")]
[NotNull]
public short LastMaxDop { get; set; }

Property Value

short

LastPauseTime

Index operation last pause time (nullable). NULL if operation is running and never paused.

[Column("last_pause_time")]
[Nullable]
public object? LastPauseTime { get; set; }

Property Value

object

Name

Name of the index. name is unique only within the object.

[Column("name")]
[NotNull]
public string Name { get; set; }

Property Value

string

Object

objects (sys.objects)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = false)]
public ObjectSchema.Object Object { get; set; }

Property Value

ObjectSchema.Object

ObjectID

ID of the object to which this index belongs (not nullable).

[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }

Property Value

int

PageCount

Total number of index pages allocated by the index build operation for the new and mapping indexes ( not nullable ).

[Column("page_count")]
[NotNull]
public long PageCount { get; set; }

Property Value

long

PartitionNumber

Partition number within the owning index or heap. For non-partitioned tables and indexes or in case all partitions are being rebuild the value of this column is NULL.

[Column("partition_number")]
[Nullable]
public int? PartitionNumber { get; set; }

Property Value

int?

PercentComplete

Index operation progress completion in % ( not nullable).

[Column("percent_complete")]
[NotNull]
public float PercentComplete { get; set; }

Property Value

float

SqlText

DDL T-SQL statement text

[Column("sql_text")]
[Nullable]
public string? SqlText { get; set; }

Property Value

string

StartTime

Index operation start time (not nullable)

[Column("start_time")]
[NotNull]
public DateTime StartTime { get; set; }

Property Value

DateTime

State

Operational state for resumable index:

0=Running

1=Pause

[Column("state")]
[NotNull]
public byte State { get; set; }

Property Value

byte

StateDesc

Description of the operational state for resumable index (running or Paused)

[Column("state_desc")]
[Nullable]
public string? StateDesc { get; set; }

Property Value

string

TotalExecutionTime

Total execution time from start time in minutes (not nullable)

[Column("total_execution_time")]
[NotNull]
public int TotalExecutionTime { get; set; }

Property Value

int