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

This table contains properties ([[#Notes|configuration options]]) and associated values used to control aspects of Sprockit's behaviour.

/* 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  |__**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.  |  |

/* 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)   ^
|(None).   ||||

==== 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 */
===== Notes =====
The following properties are available:

==== DefaultIndexRebuildFragmentationThreshold ==== 
Sprockit can optionally be configured to [[..:index maintenance|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 [[..:index maintenance|perform index maintenance tasks]]. This option controls Sprockit's default index maintenance behaviour.

==== IndexMaintenanceLogLevel ====
Sprockit can optionally be configured to [[..:index maintenance|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 [[sprockit.Handler|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 [[sprockit.Handler|handler]] capacity and demand, and adds a new handler if indicated;
  * logs handlers' [[sprockit.ExecutionActivity|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]).
    

/* 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 */