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

Disk drives with less than 5 % free space

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

5 % free disk space can have very different meaning depending on the size of the disk. To get an alert for 5 % 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 *
from dbo.v_capacity c
where convert(int, c.free_space_mb - (c.size_mb * 0.05)) <= 0
and c.post_time in
(
	select top 1 c1.post_time
	from dbo.v_capacity c1
	order by c1.post_time desc
)
and
(
	(c.size_mb between 0 and 1024 * 100 and c.free_space_mb < 1024 * 20)
	or (c.size_mb between 1024 * 100 and 1024 * 1024 and c.free_space_mb < 1024 * 50)
	or (c.size_mb between 1024 * 1024 and 1024 * 1024 * 10 and c.free_space_mb < 1024 * 100)
	or (c.size_mb > 1024 * 1024 * 10 and c.free_space_mb < 1024 * 200)
)

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