issue running report for 3 months in iConsole

Products

• CA Security Command Center
• CA Data Protection (DataMinder)
• CA User Activity Reporting

Issue/Introduction

We have an issue with running a report in the iConsole. We can run the report fine when looking up a few days or even a few weeks.  But when we run the report for a few months we run into slow downs and even errors.   We even have these issues when running this report as an Admin as well.

Environment

Release:
Component: DLPSRV

Resolution

Most of the time this issue is resolved or averted by proper database maintenance. If you run into this issue it is heavily recommended to do a clean up and defrag of your database to resolve this issue.