Configure automatic database index maintenance

Automatic database index maintenance rebuilds the fragmented indexes regularly if the index fragmentation rate exceeds the configured threshold. If the fragmentation rate doesn't exceed the threshold, an email will be sent notifying the database status.
Prerequisites
  • Make sure you have the
    Configure Database Maintenance
     permission.
To configure automatic database index maintenance
  1. On
    Tools
    , select
    Database Management
    .
  2. On
    Database Management
    , select
    Database Maintenance
    .
  3. Select the
    Schedule automatic database index maintenance
     checkbox.
  4. In the percentage list, select a value or enter any integer from 20 through 50.
  5. In the
    Start on
     list, select a date, and enter a time when the automatic database maintenance starts. Make sure that the time format follows hh:mm AM or PM.
    TIP:
    • The index rebuild process may take several minutes to complete and may impact the system performance. Set the maintenance time during a server null time when no scheduled tasks or user interaction is taking place if possible.
    • When updating from FactoryTalk AssetCentre version 10.00.00 to version 11.00.00, it is recommended to customize the date and time settings. If not, the automatic database maintenance will follow the previous configuration in version 10.00.00.
  6. In the
    week(s)
    box, select the up and down arrow or enter an integer as the frequency for automatic database maintenance.
  7. Next to the
    Email notification
     box, select the browse button, and then choose the email recipients to receive the database maintenance status. Select
    Submit
    .
  8. Select
    Save
    .
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal