Alert "Alert me when volume has less than 60 days of capacity left" alerts on Physical Memory

The Alert "Alert me when volume has less than 60 days of capacity left" is triggered by Physical Memory

The trigger conditions seem to only check volumes, so why is this alert triggered by memory? How can I make this alert only check disks?

Trigger Condition:

Trigger Condition:
SELECT VolumesForecastCapacity.Uri, VolumesForecastCapacity.DisplayName FROM Orion.VolumesForecastCapacity AS VolumesForecastCapacity
 LEFT JOIN Orion.Nodes nodes on nodes.NodeID = VolumesForecastCapacity.NodeID
								LEFT JOIN Orion.Settings s ON s.SettingID = 'ForecastMinDays' 
WHERE 
  VolumesForecastCapacity.DaysToCapacityAvg <= 60
  AND VolumesForecastCapacity.MetricName = 'Forecast.Metric.PercentDiskUsed'
  AND DayDiff(VolumesForecastCapacity.MinDateTime, VolumesForecastCapacity.MaxDateTime) >= ISNULL(s.CurrentValue, 7)
  AND  nodes.Unmanaged = false

Find more posts tagged with

Alerts

Accepted answers

stevenstadel

Add in a condition to the WHERE condition like

AND [VolumesForecastCapacity].Volume.Type = 'Fixed Disk'

or you could use

AND [VolumesForecastCapacity].InstanceCaption not like '%Memory%'

I also like to add a custom property to the Volumes to specifically call out disks that should be ignored from the alert. (Like self cleaning video recording servers etc)

AND [VolumesForecastCapacity].Volume.CustomProperties.V_IgnoreDisk != '1'

All comments

aLTeReGo

When you click 'List Resources' you will see memory listed as volume. You can deselect this if you wish, or you can narrow down the scope of your alert to trigger only on volumes of type Fixed Disk to eliminate memory volumes from triggering the alert.

JoachimT

I see the resources there. I only want to have ""Alert me when volume has less than 60 days of capacity left"" only used on volumes/disks. When I deselect memory in the "List resources". willIi still be able to get warnings if the memory is used >90% for a period of time?

JoachimT

Can you please help me with "you can narrow down the scope of your alert to trigger only on volumes of type Fixed Disk to eliminate memory volumes from triggering the alert."? There is no scope in this alert, its a "Custom SQWL Alert (Advanced)" that has no scope.

mestasew

This is one of the problematic alert and is not that much exact with its prediction as well in my opinion.

If we deselect memory under volumes resource list , we will be still getting monitoring notification for memory from CPU and Memory resource monitoring.

however we will be still missing virtual memory monitoring and would like to share a way to limit the scope to fixed disk only.

stevenstadel

Add in a condition to the WHERE condition like

AND [VolumesForecastCapacity].Volume.Type = 'Fixed Disk'

or you could use

AND [VolumesForecastCapacity].InstanceCaption not like '%Memory%'

I also like to add a custom property to the Volumes to specifically call out disks that should be ignored from the alert. (Like self cleaning video recording servers etc)

AND [VolumesForecastCapacity].Volume.CustomProperties.V_IgnoreDisk != '1'

JoachimT

That's a great answer and solution, thanks a lot