Hi,
As you reduce the value in the granularity option in LR analysis, the spikes are bound to increase.
The interval at which each sample is displayed is the granularity of the graph. A similar but not exact analogy exists with scale in maps. The larger the scale, you will see smother edges in the graph and if we reduce the scale, more and more rough edges on the map can be seen.
To put it differently, if you have granularity of 5 mins, LR will get a mean value of all the samples collected in that 5 min. In an hour scenario, you can only see 12 data points. In other words, you have 12 data points which are a mean of the samples collected during each interval of 5 min. However, if the granularity is reduced to 1 min, total of 60 data points can be seen on the graph. This translates to 60 data points which are the mean of samples collected during each interval of 1 min. In almost all cases, the variation in 5 min sets of mean will always less than the variation in 1 min sets of mean. This explains the spikes you are seeing.
This is the expected behavior of any tool that displays graph. Let me know if I need to make it more clearer.
Note: The rate at which samples are collected is called the sampling rate, while rate at which samples are displayed is the granularity. So in any case you can never have granularity less than the sampling rate.
Cheers,
Perf Trainer