/* 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]]. When a process is complete, the [[sprockit.Handler|handler]] that executed it performs index maintenance on its outputs, as required.
    
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 the maximum configured for the resource) \\ • 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.5: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 */