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.
Columns
| 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
Relationships with integrity enforced by a foreign key constraint have identifiers prefixed with FK; others are prefixed RL.
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). | ||
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.