HP XP7 Storage User Manual
Page 44
1.
Using write-workload data imported into a spreadsheet and your RPO, calculate write
rolling-averages.
For example, if RPO time is 1 hour, then 60-minute rolling averages are calculated. Do this
by arranging the values in six 10-minute intervals, as follows:
1.
In cell E4 type, =average(b2:b7), and press Enter. (Most spreadsheet tools have an
average function.)
This instructs the tool to calculate the average value in cells B2 through B7 (six 10-minute
intervals) and populate cell E4 with that data. (The calculations used here are
for example purposes only. Base your calculations on your RPO
.)
2.
Copy the value that displays in E4.
3.
Highlight cells E5 to the last E cell of workload data in the spreadsheet.
4.
Right-click the highlighted cells and select the Paste option.
Excel maintains the logic and increments the formula values initially entered in E4. It then
calculates all the 60-minute averages for every 10-minute increment, and populates the
E cells. This is shown in the following figure, which is an example using Microsoft Excel.
For comparison, 24-hour rolling averages are also shown.
Figure 7 Rolling averages calculated using 60 minute RPO
For another perspective, you can graph the data, as shown in
.
Figure 8 60-Minute rolling averages graphed over raw data
44
Planning the data path