Active Storage Manager overview

IEE Active Storage Manager is a licensed module for optimizing the storage of your reading data by using different performance tiers of customer SAN/NAS storage systems, for example Azure Net files provide performance by tier, to store IEE data at different points in its lifecycle.

The key to doing this is by leveraging the partitions in IEE’s large relational database management system, which stores data by day, week, month, and so on.

The module allows you to keep a specified number of months of the IEE partitioned tables on premium storage disk types with fast IOs, then move older data to slower, standard, less-costly disk arrays when fast access to that data is no longer required. By default, Active Storage Manager supports the following partitioned tables to be compressed:

• AGENTOUTCOMEDATA

• AGENTOUTCOMEEVENT

• DEVICECOMMLOG

• DEVICEEVENT

• SYSNOTIFICATIONHIST

• SYSNOTIFICATIONHISTGRP

• READING

• READINGGROUPSPC

• REGISTERREADING

• VALIDATIONLOGDETAILHISTORY

• VALIDATIONLOGHISTORY

To modify the default partitioned table list:

Update setting

Set SettingValue = '<partitioned table list here>' (for example, Set SettingValue = 'READING,READINGGROUPSPC,REGISTERREADING')

Where xpath = '/Itron.EE.Common.SystemSettings.DatabaseSettings/m_ActiveArchive_SupportedPartitionedTables';

When the data is no longer needed, such as at the end of a regulatory retention period, you can then choose to purge partitions using existing IEE capabilities, such as the PurgeByPartition task.

Benefits of Active Storage Manager include:

• Cost Control

• Integrated Task Management

• Resource Use

For more information, see Benefits of Active Storage Manager.