Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Consider adding Size measure to TS Events #28

Open
mcoles opened this issue Feb 7, 2020 · 1 comment
Open

Consider adding Size measure to TS Events #28

mcoles opened this issue Feb 7, 2020 · 1 comment
Labels
enhancement New feature or request

Comments

@mcoles
Copy link
Contributor

mcoles commented Feb 7, 2020

Both hist_workbooks and hist_datasources contain a size column, which should track the size of a given workbook or data source over time as it is changed. This could be useful for tracking ETL issues, or the growth of purely incremental extracts, or server growth overall, potentially.

Interestingly, looking at this data right now, the sizes for a single workbook look like they can vary wildly over time. I'm not entirely sure why that would be the case, so it'd be wise to dive into this data a bit more before just throwing that field into the data source.

@mcoles mcoles added the enhancement New feature or request label Feb 7, 2020
@mcoles
Copy link
Contributor Author

mcoles commented Feb 7, 2020

After having played with this, I think it can be useful, but you really have to be careful what you infer from it. Aggregating it to the Server level doesn't make a ton of sense, because the size values will only be present during the time frame where some event actually occurred on the workbook / data source. So it can present a very misleading story if you aren't aware that it's being aggregated once for one workbook that refreshes weekly, and seven times for a workbook that refreshes daily.

That said, it is great to have to look at the growth of individual workbooks or data sources over time. Line charts work best for this given the lack of data across some time periods.

Anyway, all that is to say that we should probably add this, but add a thoughtful comment on the way to safely use it.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant