Maintenance tasks for IEM and SQL Server

1

(imported topic written by DENFG)

Some clients are asked, if there are some tasks required for the maintenance of the IEM server and its SQL database.

If someone can help to know if there are some taks to apply for mantenaince, I appreciate.

Thank you very much.

2

(imported comment written by Tim.Rice)

Keep in mind that every environment is unique and the frequency I list for these actions is based on the internal needs of the organization I work for and the scale of our deployment and the servers that host the system.

In my IEM Environment I do the following … (accomplished with Scheduled Tasks using the Command Line Utilities) …

  • Remove Duplicate Computers (Nightly)
  • Delete Non-Reporting Computers (not reporting after 90 days)
  • Purge Deleted Computers (deleted computers older than 180 days)
  • Delete Stopped/Expired Actions (older than 90 day)

In the SQL databases we do the following … (accomplished with Maintenance Plans in the SQL Server) …

  • Regenerate Statistics (weekly)
  • Re-index the database (weekly)
3

(imported comment written by DENFG)

Ok Understood

Thank you very much for your clarification and help.

4

(imported comment written by jgstew)

Also, backup the DB and run the audit trail cleaner periodically.