Skip to main content
How can we help?
< All Topics
Print

Disk drives with less than 20 % free space

An alert will be thrown if the available free disk space is below 20 %.

20 % free disk space can have very different meaning depending on the size of the disk. To get an alert for 20 % free disk space of a 100 TB disk, would not make sense. Therefore the alert is only thrown in the following scenarios:

  • Disk size is less than 100 GB and free disk space is below 20 GB
  • Disk size is between 100 GB and 1 TB and free disk space is below 50 GB
  • Disk size is between 1 TB and 10 TB and free disk space is below 100 GB
  • Disk size is above 10 TB and free disk space is below 200 GB

To query the Performance Store database for disk drives with less than 20 % free space, use:

select c.*
from dbo.v_capacity c
where c.post_time in
(
	select top 1 c1.post_time
	from dbo.v_capacity c1
	order by c1.post_time desc
)
and c.below_20_pct_full = 1

The alert will be visible on the Latest stats dashboard.

To exclude specific servers from this alert, see how to use the dbo.team_alert_exclude table in Alerting.

Table of Contents