cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 12

Alert on Volume Growth

Jump to solution

How to create an alert when the disk usage of a volume grows say 10GB in 5 mins? Is this possible using a SWQL query or the like even?

1 Solution
Level 8

Hi @shocko! You can probably generate an alert using a SWQL condition similar to the 100% Disk capacity out-of-the-box alert. That condition is "DayDiff(getdate(), datastores.DepletionDate)<7". That condition coupled with capacity forecasting could get you the result you're looking for. Hope this helps getting started! 

View solution in original post

2 Replies
Level 12

I made something like that last year. You can look here: https://thwack.solarwinds.com/t5/Alert-Lab-Discussions/Alerting-on-Volume-Growth/m-p/316517/highligh... 

Or try this copy-n-paste from what I wrote there:

SELECT Volumes.FullName, Volumes.VolumeID FROM Volumes
Inner join [dbo].[VolumeUsage_Detail]  D on Volumes.VolumeID=d.VolumeID
where
D.datetime>Dateadd(HOUR,-2,Getdate())  -- In how many hours
AND Volumes.VolumeTypeID=4
group by Volumes.FullName, Volumes.VolumeID
HAVING Max(D.PercentDiskUsed)-Min(D.PercentDiskUsed)>10  -- Growth to look for in percent

Adjust hours and percent growth as you want.

(By default orion polls volume usage every 10 min so that would be minimum time if you don't change that.)

 

Level 8

Hi @shocko! You can probably generate an alert using a SWQL condition similar to the 100% Disk capacity out-of-the-box alert. That condition is "DayDiff(getdate(), datastores.DepletionDate)<7". That condition coupled with capacity forecasting could get you the result you're looking for. Hope this helps getting started! 

View solution in original post