Table of Contents

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 versions √ Azure SQL Database √ Azure SQL Managed Instance √ SQL database in Microsoft Fabric

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
ObjectSchema.IndexResumableOperation
Inherited Members
Extension Methods

Properties

IndexID

index_id NOT NULL int

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 NOT NULL smallint

Last MAX_DOP used (default = 0) 
[Column("last_max_dop")]
[NotNull]
public short LastMaxDop { get; set; }

Property Value

short

LastPauseTime

last_pause_time NULL datetime

Index operation last pause time (nullable). NULL if operation is running and never paused. 
[Column("last_pause_time")]
[Nullable]
public DateTime? LastPauseTime { get; set; }

Property Value

DateTime?

Name

name NOT NULL sysname

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

object_id NOT NULL int

ID of the object to which this index belongs (not nullable). 
[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }

Property Value

int

PageCount

page_count NOT NULL bigint

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 NULL int

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

percent_complete NOT NULL real

Index operation progress completion in % ( not nullable). 
[Column("percent_complete")]
[NotNull]
public float PercentComplete { get; set; }

Property Value

float

SqlText

sql_text NULL nvarchar(max)

DDL T-SQL statement text 
[Column("sql_text")]
[Nullable]
public string? SqlText { get; set; }

Property Value

string

StartTime

start_time NOT NULL datetime

Index operation start time (not nullable) 
[Column("start_time")]
[NotNull]
public DateTime StartTime { get; set; }

Property Value

DateTime

State

state NOT NULL tinyint

Operational state for resumable index:

0=Running

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

Property Value

byte

StateDesc

state_desc NULL nvarchar(60)

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 NOT NULL int

Total execution time from start time in minutes (not nullable) 
[Column("total_execution_time")]
[NotNull]
public int TotalExecutionTime { get; set; }

Property Value

int