aaStorageLocationUpdate

StorageType

The type of storage used for the specified location. 1 = Circular; 2 = Alternate; 3 = Buffer; 4 = Permanent, 5 = Tag data index, 6 = Tag data index write-ahead logs, 7 = Revision tag data write-ahead logs. There can be only one storage location of each type. This value is of data type int, with no default.

StorageNodeKey

The unique numerical identifier for the storage node. This value is of data type int, with no default.

SortOrder

Applies only to the alternate area. If more than one location is defined, the sort order determines the order in which the alternate areas are used. Reserved for future use. This value is of data type int, with no default.

Path

The path to the storage location. The circular storage location must be a local drive on the server machine, and the path must be specified using normal drive letter notation (for example, c:\Historian\Data\Circular). While the alternate, buffer, and permanent storage locations can be anywhere on the network, it is strongly recommended to have the alternate storage location configured on a dedicated physical drive locally attached by a high-speed interface to the Historian server or configured to be on a different internal hard drive. If you use a network location, the InSQLConfiguration virtual service account must have full access to the location. You can grant that access by using the credentials of the computer account in the format <domain_name>\<computer_name>$. The locations must be specified using UNC notation. Mapped drives are not supported. This value is of data type nvarchar(255), with no default.

MaxMBSize

The limit, in megabytes, for the amount of data to be stored to the specified location. The maximum size applies to circular and alternate storage only. If the maximum size is set to 0, all available space at the storage location is used. This value is of data type int, with no default.

MinMBThreshold

The minimum amount of disk space, in megabytes, at which the system attempts to start freeing up space. The threshold applies to circular and alternate storage only. Typically, you should multiply the size of the average history block (before any compression) by 1.5 to determine the minimum threshold. This value is of data type int, with no default.

MaxAgeThreshold

The age, in days, of data that will be deleted by system to free up disk space. The threshold applies to circular and alternate storage only. The minimum age is 2 days. A value of 0 indicates that no age threshold is applied. This value is of data type int, with a default of 0.