To remedy the problem, you can change the roll-up interval to flatten the line and gain a better understanding of the overall trend.
Now, because I am not taxing my lab environment, it isn't going to be as dramatic as it was for this particular customer. For my host labesx04.home.virtlab.com, I am going to select the Details tab, which provides me with a list of Views. I am going to scroll down until I see Host Memory Usage and Demand (%) Trend View. When I click on the name of the View, it is going to display in the panel below.
Next, I am going to click on the clock icon and change my roll up interval to 1 Day.
This flattens out my trend line and provides a more consumable perspective of the overall capacity, especially when you have dramatic spikes.
If I wanted to make a View that defaults to 1 day, I would click on the Clone View icon while having the Host Memory Usage and Demand (%) Trend View selected.
I am going to call my new View 1-Day Interval Host Memory Usage and Demand (%) Trend View. Also, we are going to expand advanced settings and change the roll up interval to 1 Day. You have to do this for both Memory|Usage (%) and Memory|Demand|Workload (%).
When you select the newly created View from the list, it will show the flattened trends lines in the chart.
If we wanted to create a scheduled report based on this view to keep track of capacity trending, we would click on the Reports tab and then click the green + icon.
We are going to enter the name for our report; I used Host Memory Usage and Demand (%) Trend View and noted that it was 1-Day Interval in the description.
Drag the 1-Day Interval Host Memory Usage and Demand (%) Trend View to the right panel, it should show you a preview of the report.
I kept the defaults for Formats and Layout Options then clicked Save. Like the image below, now your report should show in the list of available reports. We are going to click on the Schedules link.
I setup the schedule to run on a weekly basis and include the email distribution list to mail this out to the IT operations management team.