Is it possible to create an alert based on disk space usage change percentage?

Yes. it's possible. It would be a custom SQL alert and would like below. Below is for over 10% in 2 hours. Just change these two values as per your requirement.

The bottom half of the query to complete is below for your convenience.

LEFT JOIN VolumeUsage_Detail V

ON Volumes.VolumeID = V.VolumeID

AND Volumes.VolumeType = 'fixed disk'

AND DATEDIFF(HH,DateTime, GETDATE()) < 2

GROUP BY Volumes.NodeID, Volumes.VolumeID, Volumes.FullName

HAVING MAX(PercentDiskUsed) - MIN(PercentDiskUsed) > 10

This is perfect. Just what I have been looking for.. Now how can I change the scope to a selection of servers or volumes...

something like nodename contains "xxx" or volumeid in the list of "volume1, volume2, etc"

Easiest way is perhaps Volume custom properties. The SQL should only change by 1 additional criteria like Volumes.CustomProperty1 = 'Yes' (may not be the exact names but you get the idea)

tomiannelli​ sounds like an easier way to monitor what you monitor for storage, maybe?

designerfx​ I do like this solution, by HolyGuacamole, for way to alert on a dramatic change in the last 24 hours. So from day to day it highlights a change. The approach we took was too try and look at longer range and say, was this change out of the ordinary. Our workers can have a project [volume] sit ideal for days. Then work on large drawing sets and cause a very large change. So to tell if it is ordinary or not we needed some longer sample sets and a bit more statistically.

Naturally this won't pick up long term trends as you yourself note, but it absolutely will pick up if a project volume changes should you tune this accordingly.

Thank You So Much!

This worked perfectly!

We are quite excited to get this information in a more proactive state rather then waiting for the high % usage crisis alerts.

Great! Please share the entire SQL for the benefit of the community

After adding a custom volume property to all the volumes associated with the nodes needing to be monitored, here is the SQL code I used. It monitors volumes having an ID of 'XXXXX' that have change 10% over 2 hrs.

LEFT JOIN VolumeUsage_Detail V

ON Volumes.VolumeID = V.VolumeID

AND Volumes.VolumeType = 'fixed disk'

AND Volumes.Vol_ID = 'XXXXX'

AND DATEDIFF(HH,DateTime, GETDATE()) < 2

GROUP BY Volumes.NodeID, Volumes.VolumeID, Volumes.FullName

HAVING MAX(PercentDiskUsed) - MIN(PercentDiskUsed) > 10

This answer was a good start, but alerting with regards to max vs. min can give false alerts. For example, if I clean out a volume more than 10% it will alert. What I need is the last line to subtract the most recent PercentDiskUsed from the minimum. How would I do this?