Grooper Help - Version 25.0
25.0.0017 2,127
  • Overview
  • Help Status

Root - System Maintenance

Root Command Grooper

Performs a set of system maintenance operations on the Grooper repository, including database index rebuilds, log and statistics purging, machine cleanup, and batch/test data management.

Remarks

Overview

The System Maintenance command provides administrators with a unified interface for performing essential maintenance tasks on the Grooper repository. These operations help ensure optimal performance, manage storage, and maintain the health of the system.

Supported Maintenance Operations

  • Rebuild Indexes:
    Rebuilds all database table indexes to improve query performance. Recommended when index fragmentation exceeds 30%.
  • Clean Machines List:
    Removes machines from the Machines folder that have not connected in the last 30 days.
  • Purge Statistics:
    Deletes statistics data older than the specified retention period.
  • Purge Log:
    Deletes event log entries older than the specified retention period.
  • Purge Jobs:
    Deletes Processing Jobs and associated Processing Tasks older than the specified retention period.
  • Purge Ad Hoc Jobs:
    Deletes ad hoc Processing Jobs created by activity testing, older than the specified retention period.
  • Purge Test Batches:
    Deletes batches in specified test folders that meet the configured age criteria.
  • Purge Orphaned Tasks:
    Deletes Processing Tasks that no longer have a parent node in the repository.

Usage

Use this command to perform regular maintenance on the Grooper repository, especially in production environments or after significant data changes.

  • Multiple maintenance actions can be selected and executed in a single operation.
  • Retention periods for logs, statistics, jobs, and ad hoc jobs are configurable.
  • Purging actions are permanent and cannot be undone.
  • The command is only available to users with database alteration permissions.

Best Practices

  • Schedule regular maintenance to prevent database bloat and maintain performance.
  • Review retention periods to ensure compliance with organizational data policies.
  • Use the index rebuild feature after large data imports or when performance degrades.
  • Clean the machines list periodically to remove obsolete or decommissioned servers.

Properties

NameTypeDescription

See Also

Notification