Great news! Our brilliant engineers from the Customer Service Department developed a very useful and, I would say, critically important tool that helps Sitecore administrators in maintenance activities on the OMS 1.x database.

First off, it is well integrated into Sitecore’s Control Panel:

and provides a really nice wizard based interface that guides the user through main admin and maintenance tasks:

Looks very native if you ask me.

Here is where you can find more about it:

And here is a snippet from the project’s description:

This module provides a set of tasks that might be helpful to optimize the using of Sitecore Analytics…

  • Clean up the unnecessary data from the Analytics database.
  • Remove BOTs sessions.
  • Perform the indexes rebuilding of the Analytics database.
  • Quickly create a backup of the analytics data.
  • Synchronize the Analytics Definitions to use the clean Analytics database on the existing solution.http://trac.sitecore.net/AnalyticsDatabaseManager