StorageShard

(FK)
ShardId

uniqueidentifier, NOT NULL

The unique identifier for the partition (shard).

ShardName

nvarchar(255), NOT NULL

The name of the partition.

Description

nvarchar (512), NULL

The description of the partition.

ComputerName

nvarchar (255), NULL

The network name of the computer on which the storage partition resides.

BlockDuration

int, NOT NULL

Duration, in hours, for history blocks. Valid values are: 1, 2, 3, 4, 6, 8, 12, 24. The default is 24 hours. The history block size must always be greater than the highest scan rate. For more information, see Manage partitions and history blocks in the AVEVA Historian Administration Guide.

TimeUnitId

tinyint, NOT NULL

Foreign key to TimeUnit. Indicates whether the block duration is in hours/days.

TimeZoneId

smallint, NULL

The time zone associated with this storage partition.

AdjustToDST

tinyint, NOT NULL

Internal use only.

MaxSnapshotSize

int, NOT NULL

Maximum size, in MB, for data storage snapshots in memory. Bigger snapshots allow for faster retrieval. You might need to increase this size for systems with very high data rates. For example, if retrieval is slow from data in the current history block, try increasing this rate. Also be sure that you have enough RAM, up to 1 GB.

CmdArgs

nvarchar(4000), NULL

Do not edit.

These are command line parameters for customizing replication and storage execution.

CmdExtArgs

nvarchar(4000), NULL

Do not edit.

These are command line parameters for customizing replication and storage execution.

Id

int, NOT NULL

The unique identifier for the object.

Status

tinyint, NULL

Automatically updated by the system if a change is made to the replication group:
0 = No change; 1 = Insertion;
2 = Modification; 3 = Deletion.

UseIndexing

bit, NOT NULL

Determines whether indexing is used during low-level retrieval.

0 = Indexing disabled; 1 = Indexing enabled