Preserve instance performance by applying table rotation.

Before you begin

Contact ServiceNow Technical Support before applying table rotation to a custom table.

Role required: admin

Procedure

  1. Navigate to All > System Definition > Table Rotations.
  2. Select New.
  3. On the form, fill in the fields.
    Table 1. Table Rotation Group form
    Field Description
    Name The name of the table.
    Type The type of rotation.

    Select Rotation.
    Rotations The number of tables to maintain through the duration.
    Duration The days and hours during which data is written to each shard.
    Clean base rotation The date to clean (truncate) the base table.
  4. Select Submit.

Result

A schedule is created and new data is written to one of the tables in the rotation group. The group includes the original table plus several additional tables.

Note: Deleting a rotation deletes the additional tables and all the data. Do not delete the rotation if you still need the data.

Example: New table rotation group

New table rotation group.