Updating advanced storage area statistics

Use the AdvancedStorage::ForceUpdate advanced storage area search function to update the file count and file bytes statistics for a particular advanced storage area.

About this task

AdvancedStorage::ForceUpdate obtains the current storage area element count and compressed size, then updates the storage class table with those values (overriding the existing values).

The search function returns false if the counters are not updated. The update might fail due to timeouts, deadlocks, and other potential concurrency issues. To avoid these types of problems, and to capture statistics at a time when the state of the system is well-known, plan this operations during a maintenance window when document ingestion and deletion can be quieted.

UPDATE STORAGECLASS SET ELEMENT_COUNT = <ElementCount>, ELEMENT_KBYTES = <CompressedSize('kb')>
WHERE OBJECT_ID = <storage-area-id>

Procedure

  1. Ensure the AdvancedStorage::ForceUpdate search function is installed in the object store where the advanced storage area resides. For information about installing and using the advanced storage area search functions, see Viewing current information for advanced storage area statistics.
  2. In the administration console for Content Engine, navigate to object store > Administrative > Storage > Advanced Storage > Advanced Storage Areas > storage area and determine its Display name.

    For example, advanced storage area name ASAOS3.

  3. In the Search dialog, create a New Object Store Search
  4. In the SQL View, paste a Content Engine SQL query to execute the advanced storage area search function AdvancedStorage::ForceUpdate to force an update of the internal counters.

Example

The following statement updates the counters for the advanced storage area "ASAOS3":

SELECT [This], AdvancedStorage::ForceUpdate(this)
FROM [CmAdvancedStorageArea]
WHERE [DisplayName] = 'ASAOS3'