0

Question: Based on the following storage space statistics of my Azure SQL Managed Instance:

  1. What does the "storage space used (avg) 51.76k" (shown at the bottom of the image1 below) represent
  2. the value 51.76k relates to which value in the stats table below?

Why the Question: I am asking it because whenever I create an alert with a condition: "When Storage space use is greater than x", then even if I set the value of x to be 52, 55, or even 50510, the alert gets triggered and sends me an email. But I am not making any changes in the databases in my Azure SQL managed instance.

I can see that my stats query is still returning the same values (shown in table below), and the matric view (shown in image 1 below) is also not changing. So, why the alert gets triggered 5 minutes after I create it. This happened all three times when I created an alert for threshold of 52,55, and 50510 respectively. There must be something I am not doing right because I thought the alert will only get triggered if the threshold exceeds, say, 50510.

In my Azure SQL Managed Instance, SSMS is showing my data statistics as follows:

|volume_mount_point| used_gb | available_gb  | total_gb |
|----------------------------|---------------|----------|
|        c:\       |   0.2   |    191.8      |  192.0   |
|       http://    |   50.5  |     333.5      |  384.0   |

And the Metric view is as follows:

enter image description here

Details:

I am following this tutorial from MS Azure team describes how to creates an Alert Rule to send an alert by using following values (also shown in image 1 below):

Metric: Storage Space used
Condition: When Space used is greater than 1840876 MB

Now item 7 of this section of the article states: "value of 1840876 MB is used representing a threshold value of 1.8 TB". And then a value "1.84M" is shown in the bottom section of the image 1.

enter image description here

nam
  • 21,967
  • 37
  • 158
  • 332
  • Please don't (ab)use code markdown for quoting and names (of products); it isn't code. I've edited it out of this question, but some of your other posts suffer the same issue, so please remember to not do this in future posts. Thanks. – Thom A Sep 18 '22 at 16:21
  • Could you please add the information about the approach which you followed to create the alert? – Rakesh Govindula Sep 19 '22 at 12:58

0 Answers0