sprockit.IndexMaintenanceTask

[ v1.3 ] [ v1.4 ] [ v1.5 ] [ Back to Sprockit home page ]

Sprockit can optionally be configured to maintain indexes for processes' output resources. When a process is complete, the 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 IndexMaintenanceLogLevel. Records in the table that are older (in days) than Sprockit's LogRetentionPeriod property are automatically deleted.

Column name1) 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.
RL1 ExecutionId INT Identifies the execution following which this index maintenance task was invoked.
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)

Relationships with integrity enforced by a foreign key constraint have identifiers prefixed with FK; others are prefixed RL.

Click here to view the data model diagram.

Attributes
(in this table)
Referenced table Referenced attributes
(in referenced table)
RL1 ExecutionId sprockit.Execution ExecutionId
RL2 ResourceId sprockit.Resource ResourceId
Relationship Attributes
(in referencing table)
Referenced attributes
(in this table)
(None).

Page generated from database metadata by DbScout.


1)
Columns with names in bold are non-nullable; columns with underlined names are participants in the table's primary key.