Volume delta over time alert

Question

Hi,

I am wondering if it was possible to create an alert that will trigger if the volume (hard disk) utilisation increases by X percent over Y time? E.g. 20% over 2 hours.

I have created the following custom alert in the advanced alert manager. It should trigger when the utilisation changes by 5% in less than a 2 hour window but it does not. I tested this by monitoring a local volume, then copying files on the disk to increase the utilisation percentage (43% to 60%). Running the query against the database returns the volume that I am testing against but still no alert (action is to send an npm event and write to a local log file).

(I also believe the alert will trigger if the utilisation DROPS over time as well but that's something to sort out if I can get this step working...)

Does anyone have any experience with a volume delta alert or can see where my SQL alert is incorrect?

(Alert is enabled, set to check every 1 minute, reset when no longer true, trigger all times of day)

Thanks

wolfgangvater · Accepted Answer

You did not select the time properly.

remove the line "and DATEDIFF..."

and instead add this to your WHERE clause

AND v.Datetime>=DATEADD(hour,-2,GETDATE())

this select the records of the last 2 hours from the table so that you have something to calculate Max and Min values on

so should look like this:

LEFT JOIN VolumeUsage_Detail v

ON Volumes.VolumeID = v.VolumeID

WHERE v.Datetime>=DATEADD(hour,-2,GETDATE()) AND VolumeType = 'Fixed Disk'

GROUP BY Volumes.VolumeID, Volumes.FullName

HAVING (MAX(v.PercentDiskUsed) - MIN(v.PercentDiskUsed)) > 5

Volume delta over time alert

Top Replies