Analytics and Reports: Why do database file usage numbers change based on the window viewed.
gmcquibben
Posts: 10 Bronze 1
The database file usage numbers change if I change the window I am using. If I look at a twelve hour view, my peak usage for TempDB is 389 GB. If I look at that same 12 hour period in a 7 day view, my peak usage for TempDB is 111 Gb. Why do the peak usage numbers differ?
Tagged:
Answers
From this page:
I hope that helps clarify why you are seeing different results on a graph for a larger time range.
Kind regards,
Alex
Have you visited our Help Center?
It's aggregation, not addition, so it's averaging the data in a way that should still maintain the data peaks accurately in relation to each other, which it appears to be doing. Then you are able to zoom in on the peaks to get the more accurate information from the narrower time-frame to the point where you have all the actual sampled data points displayed.
Kind regards,
Alex
Have you visited our Help Center?
How can you say, that the aggregate is measuring the peaks accurately, when the correct peak should be 389 GB and it is displaying the peak at 111 GB? It is only displaying one-third of the correct peak value.
A Maximum value for a period in time can't change in an aggregation unless you don't include it in the aggregation.
Greg
Apologies, I left off part of the sentence - it should have read - "maintain the data peaks accurately in relation to each other, which it appears to be doing", but even then, accurately may not be the best word to use.
This sentiment is supposed to be the same as what was indicated in the documentation I linked at first. The values may not be the actual values, but the peaks and troughs should be consistent when you zoom in and out, with the closer in you zoom, getting you closer to the actual values.
Kind regards,
Alex
Have you visited our Help Center?