/* Net.FireFive.ERModel.Dokuwiki.TablePage.Header-start */
====== sprockit.IndexMaintenanceTask ======
~~PAGESWITCHER~~ [ [[..:..:sprockit|Back to Sprockit home page]] ]

Sprockit can optionally be [[..:index maintenance|configured to maintain indexes]] for processes' [[sprockit.Resource|output resources]]. Index maintenance is performed on a [[sprockit.Process|process]]'s outputs, when the process is complete, by the [[sprockit.Handler|handler]] that executed the process.
    
Actions taken in the course of index maintenance are recorded here. The level of detail logged here is controlled by Sprockit's ''[[sprockit.Property#IndexMaintenanceLogLevel|IndexMaintenanceLogLevel]]''. Records in the table that are older (in days) than Sprockit's ''[[sprockit.Property#LogRetentionPeriod|LogRetentionPeriod]]'' property are automatically deleted.


/* Net.FireFive.ERModel.Dokuwiki.TablePage.Header-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Columns-start */
===== Columns =====
^ ^Column name((Columns with names in **bold** are non-nullable; columns with __underlined__ names are participants in the table's primary key.))  ^Column type  ^Description   ^Notes   ^
|PK  |__**MaintenanceTaskId**__  |INT  |Identifies this index maintenance task.  |IDENTITY  |
|  |**TaskStartDateTime**  |DATETIME  |The date and time at which the task started.  |  |
|  |**TaskEndDateTime**  |DATETIME  |The date and time at which the task ended.  |  |
|[[sprockit.Execution|RL1]]  |**ExecutionId**  |INT  |Identifies the execution following which this index maintenance task was invoked.   |  |
|[[sprockit.Resource|RL2]]  |**ResourceId**  |INT  |Identifies the (output) resource on which this index maintenance task was invoked.   |Index maintenance activities are performed on output resources only, immediately after their corresponding process has finished.  |
|  |**IndexName**  |NVARCHAR(128)  |The name of the indicated resource's index on which this index maintenance task was invoked.   |  |
|  |PartitionNumber  |INT  |The number of the indicated resource's index partition on which this index maintenance task was invoked.   |NULL in non-partitioned indexes.  |
|  |**RebuildMode**  |TINYINT  |The rebuild mode in force for the resource at [TaskStartDateTime]  |From [[sprockit.uvw_Resource]].  |
|  |**RebuildThreshold**  |TINYINT  |The rebuild threshold in force for the resource at [TaskStartDateTime]  |From [[sprockit.uvw_Resource]].  |
|  |**PercentFragmentation**  |FLOAT  |Percentage fragmentation found on inspection of the specified index (or index partition) //before// any maintenance was performed.  |  |
|  |OpenRowgroups  |BIT  |Indicates whether, on inspection, the index was found to contain open rowgroups.   |Applies to columnstore indexes only.  |
|  |**TaskOutcome**  |NVARCHAR(1024)  |The outcome of the maintenance task.  |This field may report variously: \\ • that no rebuild was requested (via [RebuildMode]) \\ • that no rebuild was required (because fragmentation was within limits) \\ • the percentage fragmentation found on inspection of the specified index (or index partition) //after// any maintenance was performed  |
|  |Maintenance SqlStatement  |NVARCHAR(1024)  |The ''ALTER INDEX'' statement used to maintain the index (if applicable)   |  |

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Columns-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Relationships-start */
===== Relationships =====
Relationships with integrity enforced by a foreign key constraint have identifiers
prefixed with //FK//; others are prefixed //RL//.

[[sprockit:v1.3:Sprockit tables:Sprockit tables|Click here to view the data model diagram.]]
==== References to other tables ====

^  ^Attributes \\ (in this table)  ^Referenced table  ^Referenced attributes \\  (in referenced table)   ^
|RL1  |ExecutionId  |[[sprockit.Execution]]  |ExecutionId  |
|RL2  |ResourceId  |[[sprockit.Resource]]  |ResourceId  |

==== References to this table from others ====

^Relationship  ^Attributes \\ (in referencing table)  ^Referenced attributes \\ (in this table)   ^
|(None).   |||


/* Net.FireFive.ERModel.Dokuwiki.TablePage.Relationships-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Notes-start */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Notes-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Footer-start */
----
Page generated from database metadata by [[https://richardswinbank.net/DbScout|DbScout]].

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Footer-end */