Restrict Analytics Reports from running during daytime

Idea ID 1791928

Restrict Analytics Reports from running during daytime

0 Votes

In the database logging we see that the Analytic reports are being generated at random times during the day. These query's can be quite long and heavy causing performance issues.

Further investigation turned out that users can schedule these reports themselves, not realizing that this has performance impact.

The workaround is to do a SQL update to delete, or reschedule at night-time, and set up a cron job to script the delete/resched task.

Proposal to restrict Analytic reports from being run every hour, or only at night.

1 Comment
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor
Status changed to: Waiting for Votes

Thank you for sharing your idea! It’s open for comments and kudos, and we’re looking forward to input from the community. Once there is enough community traction, it will be further reviewed by the product team. 

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.