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
-
Jacquelin commented
Ich verstehe den Bedarf sehr gut. Aktuell sieht man zwar die Datenbankgrössen in den Operations-Ansichten, aber ohne historische Entwicklung ist es schwierig zu erkennen, welche Datenbank wann abnormal gewachsen ist. Eine 30-Tage-Zeitreihe in BizTalk360 Analytics oder Reporting, idealerweise als Linien- oder gestapeltes Balkendiagramm, würde hier enorm helfen. So könnte das Operations-Team https://luckydreams-ch.ch/ schnell die Ursache für Speicherprobleme identifizieren und gezielt reagieren, statt nur den aktuellen Zustand zu sehen.
-
Lareina Burris
commented
Great idea. Also consider tracking autogrowth events alongside size—they often reveal fragmentation patterns missed by static snapshots, especially for tempdb during maintenance windows. https://www.timeculator.org/