1

I have an Azure SQL Server Database - Managed Instance I'd like to monitor. Here is the widget that Azure shows me on the database summary page. I'd like to put this widget, or at least the information which this widget exposes, on my comprehensive monitoring dashboard.

enter image description here

The problem is, I don't see any metric for Max Storage. Space Used vs Allocated is useless to me since Azure allocates space just-in-time as it is needed. The question I need to keep on top of is where do I stand with space used vs max storage. Is this possible?

enter image description here

Just so you don't have to take my word for it - here is a screenshot scrolled down to where M... would be. As you can see there is no entry for Max Storage.

enter image description here

Improve this question
2
  • 1
    "Azure allocates space just-in-time as it is needed" - Wouldn't that imply there is no max storage, or am I missing something?
    – J.D.
    Commented Jun 16, 2023 at 0:18
  • The full spec is - Azure allocates space just-in-time as it is needed until the Max Storage is reached. i.e. Max Storage isn't a technical limitation, it's more of a billing and accounting protection which safeguards my processing from mistakenly accumulating more space than I am willing to pay for. So we keep this in place to assure that our data accumulation proceeds at a reasonable pace and from time to time I adjust this. That's the purpose of the pie chart on the summary page and I'm looking for a way to display this prominently on my dashboard.
    – Yossi Geretz
    Commented Jun 16, 2023 at 16:12

1 Answer 1

Reset to default
1

‘Data space used percent’ metric can be useful for monitoring database storage consumption.

Improve this answer
1
  • Yes, thank you! Interesting that this metric is relative to the Max Storage metric, but Max Storage itself isn't available as a metric.
    – Yossi Geretz
    Commented Jun 16, 2023 at 16:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.