Monitor SQL disk usage and db size over time (e.g. rolling 30 day period)
We currently have monitoring in place for available disk space, and we can also review the size of the individual BizTalk-related databases in the Operations sections.
I'd like to have an additional feature (e.g. in Analytics, Reporting section) where we can have a 30-day time series of the size of the databases, in a line chart or a stacked bar chart). Reason is the, when disk space on the database server runs out, our operations team typically asks us to point out the cause. For that insight, I need to be able to see which database grows abnormally in which time frame.
Fréderic Cordier
shared this idea
-
Nadia Moore commented
To enhance our SQL monitoring, we should implement a feature that tracks database sizes over a rolling 30-day period, ideally represented in a line or stacked bar chart. This will help identify which BizTalk-related databases are growing unusually, especially when disk space issues arise. Think of it like keeping score in Retro bowl ( https://retrobowl-game.io ) ; knowing the stats lets us strategize better and avoid operational setbacks.