sprockit.Property
[ v1.3 ] [ v1.4 ] [ v1.5 ] [ Back to Sprockit home page ]
This table contains properties (configuration options) and associated values used to control aspects of Sprockit's behaviour.
Columns
| Column name1) | Column type | Description | Notes | |
|---|---|---|---|---|
| PK | PropertyName | NVARCHAR(128) | Unique property identifier. | |
| PropertyValue | NVARCHAR(MAX) | The value currently configured for this property. | ||
| DataType | NVARCHAR(128) | The property's data type. | ||
| Description | NVARCHAR(512) | A description of the property. |
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) |
|
|---|---|---|---|
| (None). | |||
References to this table from others
| Relationship | Attributes (in referencing table) | Referenced attributes (in this table) |
|---|---|---|
| (None). | ||
Notes
The following properties are available:
DefaultIndexRebuildFragmentationThreshold
Sprockit can optionally be configured to perform index maintenance tasks. This option, expressed as a percentage, indicates the maximum fragmentation permitted in an index by default before it requires maintenance.
DefaultIndexRebuildMode
Sprockit can optionally be configured to perform index maintenance tasks. This option controls Sprockit's default index maintenance behaviour.
IndexMaintenanceLogLevel
Sprockit can optionally be configured to perform index maintenance tasks. This option controls how much index maintenance activity is reported in sprockit.IndexMaintenanceTask.
LogRetentionPeriod
Sprockit trims its own log tables by removing entries over a certain age at each execution. This option specifies that age in days.
MaxConcurrentHandlers
The maximum number of process handlers permitted to run at the same time.
Typically you will find that end-to-end processing time decreases as this option's value increases, but only up to a point – a value too low will fail to make use of available resources, while a value too high will cause individual processes to become starved and slow down. You should tune this value to make best use of your system's resources.
ProcessManagerPollInterval
Sprockit's process manager runs in an infinite loop as long as processes are running. At each iteration, the process manager:
- assesses handler capacity and demand, and adds a new handler if indicated;
- logs handlers' current activity;
- waits for a number of seconds.
The number of seconds it waits before entering the next iteration is specified by this property.
RollingAverageBatchCount
The rolling average batch count indicates the number of (most recent, successful) executions to be used by Sprockit when calculating a process's average duration (recorded in sprockit.Process.[AvgDuration]).
Page generated from database metadata by DbScout.