What does Azure SQL MI space used Metrics value represents?

Faisal kayani 5 Reputation points
2023-08-28T05:56:14.2033333+00:00

What is this metrics value means in Azure SQL MI represents as the value is different from actual storage space used. Is it the used space by the data or total space used including log files and other files?

image_2023_08_28T05_27_40_243Z

Azure SQL Database
Azure AI Metrics Advisor
Azure AI Metrics Advisor
An Azure artificial intelligence analytics service that proactively monitors metrics and diagnoses issues.
80 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaktiSingh-MSFT 14,281 Reputation points Microsoft Employee
    2023-08-28T06:36:05.8166667+00:00

    Hi
    Faisal kayani     •,

    Welcome to Microsoft Q&A forum.

    As I understand, you could see come difference in Storage Space Used metrics of Azure SQL Managed Instance.

    Could you please share more information about this difference observed?

    For instance, the screenshot taken is from Diagnostic settings, and from where you found and compared that it is different?

    Note:Most metrics in Azure are stored for 93 days. You can query no more than 30 days' worth of data on any single chart. You can pan the chart to view the full retention. The 30-day limitation doesn't apply to log-based metrics.

    Let us know what Time range have you selected to view this result?

    Screenshot that shows changing the time range panel.

    Any filtering or splitting applied:

    {alt-text}

    Thanks.

    0 comments
  2. ShaktiSingh-MSFT 14,281 Reputation points Microsoft Employee
    2023-08-29T04:50:06.6766667+00:00

    Hi
    Faisal kayani     •,

    The storage that you provision is the amount of storage capacity available to your Azure Database for PostgreSQL server. The storage is used for the database files, temporary files, transaction logs, and PostgreSQL server logs. The total amount of storage that you provision also defines the I/O capacity available to your server.

    For more details refer: https://video2.skills-academy.com/en-us/azure/postgresql/flexible-server/concepts-compute-storage

    For deeper analysis for the difference you observe, you may file a support case.

    Here https://video2.skills-academy.com/en-us/azure/azure-portal/supportability/how-to-create-azure-support-request is how you can create request.

    Hope this helps.

    Thanks